Forum Discussion

jake223's avatar
jake223
Icon for Helper I rankHelper I
6 years ago

Cumulative/Running Total

Hello,   I'm having an issue with creating a Cumulative/Running Total. Currently I have the following:   StartFTE_TO = sum('92_FOM_FY20'[Current FTE for TO]) EndFTE_TO = SUM('92_FOM_FY20'[Curr...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Calculation of turnover

jake223's avatar
jake223
Icon for Helper I rankHelper I
6 years ago

amitchandak 

 

Turnover = ([TermsFTE_TO] / (([StartFTE_TO]+[EndFTE_TO]) / 2))

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hello jake223 ,

    Try changing from:

    Cumulative = CALCULATE([Turnover], FILTER(ALLSELECTED('7_Date'), '7_Date'[Date] <= MAX('7_Date'[Date])))

     

    to 

    Cumulative =
    VAR maxDate = MAX('7_Date'[Date])
    Return
    CALCULATE([Turnover], ALL('7_Date'), '7_Date'[Date] <= maxDate))

    Br,
    J

    • jake223's avatar
      jake223
      Icon for Helper I rankHelper I
      6 years ago

      tex628 

       

      I tried using and looks like that same result

       

      Cumulative =
      VAR maxDate = MAX('7_Date'[Date])
      RETURN
      CALCULATE([Turnover], ALL('7_Date'), '7_Date'[Date] <= maxDate)
       
       

       

      • tex628's avatar
        tex628
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Just to make sure, you are using a slicer on year here together with the table right? 

        What do you get if you just add:

        Cumulative =
        VAR maxDate = MAX('7_Date'[Date])
        RETURN
        maxDate