Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The following measures show how many people left the business in the rolling 12 month period, however I need this to be presented in a table as below therefore need a way of combining the two Dax measures below into one measure if possible as I want to avoid 12 measures for each column in the table.
Would appreciate any help on this!!!
P1 Leavers Prev Rolling 12 Prev Month =
CALCULATE(
COUNTROWS(Leavers),
FILTER(
ALL('Leavers'[TERMINATION DATE]),
Leavers[TERMINATION DATE] >= EOMONTH(TODAY(), - 13) +1
&&
Leavers[TERMINATION DATE] <= EOMONTH( TODAY(), -1)
)
)
////Previous rolling 12 calendar months as of today 28/11/23 will show Nov 22 - Oct 23 total figures
P2 Leavers Prev Rolling 12 Prev Month =
CALCULATE(
COUNTROWS(Leavers),
FILTER(
ALL('Leavers'[TERMINATION DATE]),
Leavers[TERMINATION DATE] >= EOMONTH(TODAY(), - 14) +1
&&
Leavers[TERMINATION DATE] <= EOMONTH( TODAY(), -2)
)
)
////Previous period of previous rolling 12 calendar months as of today 28/11/23 shows Oct 22 - Nov 23 total figures.
@GJ217 , I have created a similar calculation here with a little bit of a difference
Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |