Search found 161 matches

by PhilC
Wed Dec 12, 2018 2:40 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Page 10 Tables
Replies: 1
Views: 356

Re: Page 10 Tables

Hi waynegolds, The sentence is a bit confusing, the text in the Excel book is a bit different: Position your tables so that any data tables (there is only one in this case) are at the bottom of the screen and the lookup tables are at the top. There is also an additional box with the following descri...
by PhilC
Tue Nov 27, 2018 12:15 pm
Forum: PowerPivot/DAX
Topic: Break Lineage to get Scalar Value for Math
Replies: 2
Views: 190

Re: Break Lineage to get Scalar Value for Math

Hi, Hard to get the full picture without seeing the model. Any chance you can post an example file? Even a few screen shots to help understand the explanation. Can you post the actual measure for [% GWE Allocated Cost]? When you tested the measures to know they are independently correct, are you usi...
by PhilC
Tue Nov 27, 2018 8:18 am
Forum: Power Query
Topic: Complex grouping and summarization
Replies: 4
Views: 238

Re: Complex grouping and summarization

Hi NurlanPPF, Power Query takes a row based approach, and as such, having a result with merged cells is not possible. Can you review and revise your Summary to show the desired output with data only in a single row? Note, that the desired output may be achieved using a Pivot rather than just the tab...
by PhilC
Wed Nov 21, 2018 2:21 pm
Forum: Power Query
Topic: Multiple WEB pages with Power query
Replies: 2
Views: 244

Re: Multiple WEB pages with Power query

Hi there, Providing a sample file would help with proposing a solution, so if that is possible please post one up. I am making an assumption that the columns of the data are the same across the 30 pages, just the column headings are different. If that is correct, insert a step to demote the headers ...
by PhilC
Sun Nov 04, 2018 9:50 pm
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 847

Re: Filtering formula by various dates

Hi, thanks for following up. Still do not have it working with the slicer based on the Year column of the Calendar table. Hard coded it is fine, using the Calendar[Year] produces the correct result when I use a Card visual to test, so still stumped. Don't think the DateTime aspect mentioned is relav...
by PhilC
Tue Oct 30, 2018 12:28 pm
Forum: PowerPivot/DAX
Topic: 'Basket Analysis' pattern extension - Unique customers to a store
Replies: 1
Views: 206

Re: 'Basket Analysis' pattern extension - Unique customers to a store

If you have a mock up model with fake data that would help, but see if this heads you in the right direction. Not sure I have the syntax right for this but some trial and error might get you there. Single Store Shopper = CALCULATE( COUNTROWS( FILTER( Customers[CustomerKey], CALCULATE( COUNTROWS( Tra...
by PhilC
Sat Oct 27, 2018 8:59 pm
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 847

Re: Filtering formula by various dates

Hmm, interesting. Thanks for investigating, will have a look at the file you posted tomorrow night or Monday. Not super keen on having a different field to use as the slicer, as am using this slicer linked across multiple pages and want it to be coming off the date table as it affects other calcs in...
by PhilC
Fri Oct 26, 2018 9:09 pm
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 847

Re: Filtering formula by various dates

Thanks for having a look. I cannot understand why the measure works when the FirstYear is hard coded to 2018 but not when I use the SelectedValue. The attached PBIX has the example with your formula. It is not producing the correct result. If you change Funding Amount Current Year measure to be hard...

Go to advanced search