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]
    )
amitchandak's avatar
amitchandak
Super User
3 years ago

uie07923 , Assuming you have common date table with month year and measure fluctuation rate

 

Try a new measure

 

fluctuation rate Cumm= sumx(Values(Date[Month Year]), [fluctuation rate])

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:

 

 

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

    Hi uie07923 

    Is this what you want to see

     

  • 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]
    )