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 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)
)
)

 

 

Need Help

2 Replies

  • 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