Dax for Month to Month Variance

[Gavin_Shales]

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 out is how I can modifiy this DAX to show the numerical difference between the two months? Please could someone take a look at my DAX below and suggest how I can amend this to show the Numerical difference and not the %.

Thank you very much. Gavin

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
DIVIDE(COUNTA('TPL Pet Test'[Version]) - __PREV_MONTH, __PREV_MONTH)
)
)

[v-piga-msft]

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]

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