PowerPivot Forum

Hi Anthony, Theory is just that, and it may not always translate into the best solution for any given model. That said, those that have built many models provide best practice suggestions based on what works in many cases. Matt's post here might be a useful start: https://exceleratorbi.com.au/the-op...

This might give some ideas: https://youtu.be/hH_uiw7f900

Hi, This works with two tables names Table1 and Table2 The commented out approach also works, but requires all the potential tables to be included let QuerySelect = 2, QueryName = "Table"&Text.From(QuerySelect), Source = Record.Field(#shared, QueryName) // Source = if QuerySelect = 1 t...

Hi Kishore,

You only provided a picture of what you are calling the data model (it is really only a table), so not much can be done with a picture in terms of trying for a solution. Have asked a number of times for you to post it, can't provide anything more without it.

Cheers
Phil

Hi Ricardo, Had a bit of a look but will take a while to unpack the approach. Couple of comments for consideration: 1. Doesn't a Cash Flow start with Net Income, not EBIT, then when adding back Depreciation and other non cash aspects you do not end up with EBITDA but Net Cash from Operating Activiti...

Hi Kishore, Sorry, but I still am not getting it. The file you provided is just showing rows and columns of info where it seems the rows are repeating. Where is the input table and the measures you have tried to write etc? What you have provided as output does not make sense as it repeats rows, whic...

Hi Kishore, Thanks for posting, however it is still not clear to me what you are trying to do, sorry. The data model is the view of the tables in PowePivot, showing the relationships between them. What you have posted is a flat table, so it is hard to see how you are looking to use PowerPivot (I am ...

Hi portalturks, Please see attached, look at Users table under the data model for Target 1 and Target 2 calculated columns. Formula use is: =if(Users[Division]="AE",COUNTROWS(RELATEDTABLE(Opp))*LOOKUPVALUE('KPI'[Target1],'KPI'[Division],Users[Division]),10*LOOKUPVALUE('KPI'[Target1],'KPI'[...

Hi Anthony It sounds like the issue needing investigating is the measures you are using. My guess is you have created a measure based on the Projects table, so by adding a field from the Milestones table it can no longer calculate the Project related measure. If you need a measure to work with field...

Hi Kishore, I am a bit confused as to the data model based on the description, but in order for the "toggling" or filtering you are describing to occur, it would seem that the second table (with the values) needs to be linked to the first table (with A & B details) based on B. Having l...