Forum Discussion

Gavin_Shales's avatar
Gavin_Shales
Frequent Visitor
8 years ago

Dax for Month to Month Variance

Hello all,   I am trying to create a dashboard which will be comparing data over two months. I have used a "Quick New Measure" which is great for showing what the % difference is. What I can't work...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Gavin_Shales，

 

You could modify your measure as below then you will get the numerical difference between the two months.

 

Count of Version MoM% =
 (
    IF (
        ISFILTERED ( 'TPL Pet Test'[Version] ),
        ERROR ( "Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column." ),
        VAR __PREV_MONTH =
            CALCULATE (
                COUNTA ( 'TPL Pet Test'[Version] ),
                DATEADD ( 'TPL Pet Test'[Version].[Date], -1, MONTH )
            )
        RETURN
            COUNTA ( 'TPL Pet Test'[Version] ) - __PREV_MONTH
    )
)

Hope it can help you !

 

Best Regards, 

Cherry

Gavin_Shales's avatar
Gavin_Shales
Frequent Visitor
8 years ago

Hi Cherry,

 

Thanks for taking a look at this. Sorry for the late response, I have not had the chance to re-visit this until now.

 

Unfortunately the Dax isn't working as I hoped it would. Instead of showing the difference its just showing the total of both months combined.

 

Regards

Gavin