Search found 274 matches

by PhilC
Mon Jul 29, 2019 11:58 pm
Forum: PowerPivot/DAX
Topic: Related Tables
Replies: 3
Views: 216

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...
by PhilC
Mon Jul 29, 2019 8:26 am
Forum: PowerPivot/DAX
Topic: Cumulative sum of monthly average values
Replies: 1
Views: 131

Re: Cumulative sum of monthly average values

This might give some ideas: https://youtu.be/hH_uiw7f900
by PhilC
Thu Jul 25, 2019 12:54 pm
Forum: Power Query
Topic: Dynamic reference to query
Replies: 2
Views: 260

Re: Dynamic reference to query

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...
by PhilC
Wed Jul 24, 2019 10:10 pm
Forum: PowerPivot/DAX
Topic: DataSwap On Filtering in Display
Replies: 8
Views: 438

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
by PhilC
Wed Jul 24, 2019 8:43 am
Forum: PowerPivot/DAX
Topic: Cash Flow Indirect Method Having trouble with running sum
Replies: 2
Views: 211

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...
by PhilC
Wed Jul 24, 2019 8:02 am
Forum: PowerPivot/DAX
Topic: DataSwap On Filtering in Display
Replies: 8
Views: 438

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...
by PhilC
Tue Jul 23, 2019 8:04 am
Forum: PowerPivot/DAX
Topic: DataSwap On Filtering in Display
Replies: 8
Views: 438

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 ...
by PhilC
Mon Jul 22, 2019 1:16 pm
Forum: PowerPivot/DAX
Topic: Beginner Question
Replies: 1
Views: 133

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'[...
by PhilC
Mon Jul 22, 2019 12:51 pm
Forum: PowerPivot/DAX
Topic: Related Tables
Replies: 3
Views: 216

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...
by PhilC
Mon Jul 22, 2019 12:44 pm
Forum: PowerPivot/DAX
Topic: DataSwap On Filtering in Display
Replies: 8
Views: 438

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...

Go to advanced search

cron