Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
)
)
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |