Forum Discussion

MxJ's avatar
MxJ
Frequent Visitor
7 years ago

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])...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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,

MxJ's avatar
MxJ
Frequent Visitor
7 years ago

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.