Search found 157 matches

by PhilC
Sun Nov 04, 2018 9:50 pm
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 482

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: 89

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: 482

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:55 pm
Forum: Power BI Desktop/Service
Topic: Using a Concatante formula to show the selected filter in text box
Replies: 2
Views: 117

Re: Using a Concatante formula to show the selected filter in text box

Just came across this too:

Code: Select all

Selected = "Selected Product: " & IF(NOT(ISFILTERED(Product[Name])),"All",CONCATENATEX(ALLSELECTED(Product[Name]),Product[Name],","))
by PhilC
Fri Oct 26, 2018 9:09 pm
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 482

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...
by PhilC
Wed Oct 24, 2018 10:28 pm
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 482

Re: Filtering formula by various dates

Thanks for the suggestion. It seems like it should work based on what you provided, but the visual is showing results for more than the selected year plus two more (I did change the + 3 to +2). I tried hard coding the FirstYear value to 2018 in both measures and the result is as expected, so just ne...
by PhilC
Wed Oct 24, 2018 2:19 pm
Forum: Power Query
Topic: Group and sum delimited values
Replies: 6
Views: 382

Re: Group and sum delimited values

Had a play with techniques from these posts: https://datachant.com/2016/01/13/split-and-unpivot-comma-separated-values/ https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/ For the No Splitting example, the final couple of steps should be able to be done without using Piv...
by PhilC
Wed Oct 24, 2018 1:55 pm
Forum: Power Query
Topic: Group and sum delimited values
Replies: 6
Views: 382

Re: Group and sum delimited values

NurlanPPF wrote:Hello,
Is it possible to sum delimited values without splitting?

Please help! :?


Is there a reason you need to do this without splitting? Perhaps if this is understood can help re solution, as it can easily be done with splitting - see attached.


Cheers
Phil
by PhilC
Wed Oct 24, 2018 1:42 pm
Forum: Power BI Desktop/Service
Topic: Filtering formula by various dates
Replies: 9
Views: 482

Filtering formula by various dates

Hi, I am looking to produce a visual that shows Funding over three years (slicer selected year and next two) for two different measures, in a stacked column chart. I have attached a PIBX and Excel files with example data, and my attempt at the two formulas. I have hard coded the VARs but I need them...

Go to advanced search