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 all,
Couldn't get my "Cumulative Mthly Leavers" column to work. Would appreciate your guidance, please.
Thanks!
Vin
Solved! Go to Solution.
Hi @VinLee1314
you have to YearMonth number column in your date table. The try the following
Cumulative Mthly Leavers =
CALCULATE (
[Leavers],
'Calendar'[YearMonth] <= MAX ( 'Calendar'[YearMonth] ),
ALLSELECTED ( 'Calendar' )
)
I managed to get it working on a monthly basis. I would like the running total to continue after the year ends. How do I make changes to the DAX?
Hi @VinLee1314
you have to YearMonth number column in your date table. The try the following
Cumulative Mthly Leavers =
CALCULATE (
[Leavers],
'Calendar'[YearMonth] <= MAX ( 'Calendar'[YearMonth] ),
ALLSELECTED ( 'Calendar' )
)
// # Leavers TD = count of leavers to date
[# Leavers TD] =
var LastVisibleDate = MAX( 'Calendar'[Date] )
var Output =
CALCULATE(
[# Leavers],
'Calendar'[Date] <= LastVisibleDate,
ALLSELECTED ( 'Calendar' )
)
return
Output
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |