Hi guys,
There are few similar topics on this forum, but I have a feeling the all of them are trying to solve slighly different scenarios.
I am playing with MoM and WoW calculations.
I was able to do MoM via "Quick Measures" (in beta, you need to activate it).
I was then hoping I would take the MoM expression and edit it slighly to create WoW.
This is the DAX expression Power BI generates for MoM:
Leads MoM% =
IF(
ISFILTERED('Calendar'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy."),
VAR __PREV_MONTH =
CALCULATE(
SUM('FactTable'[Leads]),
DATEADD('Calendar'[Date].[Date], -1, MONTH)
)
RETURN
DIVIDE(SUM('FactTable'[Leads]) - __PREV_MONTH, __PREV_MONTH)
)
I found out that making WoW out of this is more difficult than expected.
I guess I need to edit this piece: DATEADD('Calendar'[Date].[Date], -1, MONTH)
The problem is that you CANNOT use WEEK instead of MONTH. WEEK is not supported.
So what do I need to put there to get WoW calculation?
DZ
