Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I have multiple measures and the business have asked me to show the same measures as a rolling 3 month number.
Here is one measure I have:
Order Count =
DISTINCTCOUNT(orders[order_number])
Here is the R3M equivalent (based on fiscal calendar):
Order Count R3M =
VAR __lastVisibleDate =
LASTDATE ( 'Time'[Date] )
VAR __financialPeriod =
MIN ( 'Time'[YearMonthKey] ) - 2
VAR __fromDate =
CALCULATE (
FIRSTDATE ( 'Time'[Date] ),
FILTER ( ALL ( 'Time' ), 'Time'[YearMonthKey] = __financialPeriod )
)
VAR __canMove3MBack =
NOT ISBLANK ( DATEADD ( __lastVisibleDate, -2, MONTH ) )
VAR __result =
CALCULATE (
[Order Count],
DATESBETWEEN('Time'[Date], __fromDate, __lastVisibleDate)
)
RETURN
IF ( __canMove3MBack, __result )
I would like to add the DAX from the R3M into a calculation group and reuse it but because my calculation is in a variable (__result) I don't know how. Is this possible?
Solved! Go to Solution.
In the calculation item (within the calculation group), replace [Order Count] with SELECTEDMEASURE(). This will make it dynamic for whatever measure is in the visual.
Proud to be a Super User!
In the calculation item (within the calculation group), replace [Order Count] with SELECTEDMEASURE(). This will make it dynamic for whatever measure is in the visual.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |