Forum Discussion
Filter on certain filter category
Hi Guys, I am using a table that shows YTD wholesale growth with the following DAX-query: Wholesale Growth = ([Total Wholesale]-Calculate([Total Wholesale];SAMEPERIODLASTYEAR(Real_date[Date])...
Hi MxJ,
Try this formula, please.
Wholesale Growth = IF ( ISBLANK ( [Total Wholesale] ); 0; ( [Total Wholesale] - CALCULATE ( [Total Wholesale]; SAMEPERIODLASTYEAR ( Real_date[Date] ) ) ) / CALCULATE ( [Total Wholesale]; SAMEPERIODLASTYEAR ( Real_date[Date] ) ) )
Best Regards,
I have tried it but unfortunatly it does not work. It sets Q2, 3, 4 on zero but still uses jan, feb, mar for Q1 2018 and only jan for Q1 2019.
Hi MxJ,
Can you share a small sample? Please mask the sensitive parts first.
What's the formula of [Total Wholesale]?
Best Regards,
On the left is my date table and on the right the wholesale table, the 2 are linked on Date = Sale_Date.
The calculation for Total Wholesale
Total Wholesale = calculate(sum('Wholesale'[Wholesale]);'Wholesale'[Segment]<>"3. Other")It sums the wholesale column and excludes one segment.
Hi MxJ,
Please download a demo from the attachment. All the date like fields should from the Real_Date table.
Best Regards,