Forum Discussion

uie07923's avatar
uie07923
Frequent Visitor
3 years ago
Solved

Cumulative - % Monthly Rate

Hello all,   I'm struggling to reach the cumulative fluctuation rate. Every month end, we extract a headcount total. During that month there are employee exits. The rate between Exits / Total Hea...
Need Help
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    Maybe try this:

    fluctuation rate Cumm = 
    SUMX(
        FILTER(
            ALL( dCalendar[YearMonth] ),
            dCalendar[YearMonth] <= MAX( 'dCalendar'[YearMonth] )
        ),
        [fluctuation]
    )
uie07923's avatar
uie07923
Frequent Visitor
3 years ago

Are you considering the creation of an additional table with only the results of the fluctuation rate?

I tried the measure, but it didn't work:

 

 

grantsamborn's avatar
grantsamborn
Solution Sage
3 years ago

Maybe try this:

fluctuation rate Cumm = 
    SUMX(
        FILTER(
            ALL( dCalendar[YearMonth] ),
            dCalendar[YearMonth] <= MAX( 'dCalendar'[YearMonth] )
        ),
        [fluctuation]
    )