Forum Discussion
MoM % Variance
Hi Everybody, first post, I am a rookie at this stuff and for the life of me can't seem to figure out the correct DAX for MoM % Variance. I'm self-taught and done pretty well so far, but I must be m...
Figured it out with the builtin Quick Measure suggestions, I thought since it was showing me an error it wasn't working, but the calculations appear to be correct regardless of the error. Thanks everyone
Exposure Balance MoM% =
IF(
ISFILTERED('Exposure Balance Monthly'[Snapshot Month]),
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(
SUM('Exposure Balance Monthly'[Exposure Balance]),
DATEADD('Exposure Balance Monthly'[Snapshot Month].[Date], -1, MONTH)
)
RETURN
DIVIDE(
SUM('Exposure Balance Monthly'[Exposure Balance]) - __PREV_MONTH,
__PREV_MONTH
)
)