Search found 274 matches
- Mon Jul 29, 2019 11:58 pm
- Forum: PowerPivot/DAX
- Topic: Related Tables
- Replies: 3
- Views: 360
Re: Related Tables
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...
- Mon Jul 29, 2019 8:26 am
- Forum: PowerPivot/DAX
- Topic: Cumulative sum of monthly average values
- Replies: 1
- Views: 217
Re: Cumulative sum of monthly average values
This might give some ideas: https://youtu.be/hH_uiw7f900
- Thu Jul 25, 2019 12:54 pm
- Forum: Power Query
- Topic: Dynamic reference to query [Solved]
- Replies: 2
- Views: 429
Re: Dynamic reference to query [Solved]
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...
- Wed Jul 24, 2019 10:10 pm
- Forum: PowerPivot/DAX
- Topic: DataSwap On Filtering in Display
- Replies: 8
- Views: 704
Re: DataSwap On Filtering in Display
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
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
- Wed Jul 24, 2019 8:43 am
- Forum: PowerPivot/DAX
- Topic: Cash Flow Indirect Method Having trouble with running sum
- Replies: 2
- Views: 346
Re: Cash Flow Indirect Method Having trouble with running sum
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...
- Wed Jul 24, 2019 8:02 am
- Forum: PowerPivot/DAX
- Topic: DataSwap On Filtering in Display
- Replies: 8
- Views: 704
Re: DataSwap On Filtering in Display
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...
- Tue Jul 23, 2019 8:04 am
- Forum: PowerPivot/DAX
- Topic: DataSwap On Filtering in Display
- Replies: 8
- Views: 704
Re: DataSwap On Filtering in Display
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 ...
- Mon Jul 22, 2019 1:16 pm
- Forum: PowerPivot/DAX
- Topic: Beginner Question
- Replies: 1
- Views: 225
Re: Beginner Question
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'[...
- Mon Jul 22, 2019 12:51 pm
- Forum: PowerPivot/DAX
- Topic: Related Tables
- Replies: 3
- Views: 360
Re: Related Tables
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...
- Mon Jul 22, 2019 12:44 pm
- Forum: PowerPivot/DAX
- Topic: DataSwap On Filtering in Display
- Replies: 8
- Views: 704
Re: DataSwap On Filtering in Display
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...