Forum Discussion

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

3 years ago

Maybe try this:

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