Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Cumulative base on 3 column

Hi good day can anyone help me on my calculated column, i need the cumulative sum of Treade base from Area, Week No. and Trade DESIRED OUTPUT Thank you
  • wardy912's avatar
    1 year ago

    Hi AllanBerces 

     Try this

    Cumulative_Trade = 
    CALCULATE(
        SUM('YourTable'[Weekly_Pl]),
        FILTER(
            ALL('YourTable'),
            'YourTable'[Area] = EARLIER('YourTable'[Area]) &&
            'YourTable'[Trade] = EARLIER('YourTable'[Trade]) &&
            'YourTable'[Week No.] <= EARLIER('YourTable'[Week No.])
        )
    )

     

    Hope this helps, please give a thumbs up and mark as solved if it does, thanks!

  • SamWiseOwl's avatar
    1 year ago

    Hi AllanBerces 

     

    Cum_Trade =
    var CurrentArea = [Area]
    var CurrentWeek = [Week No.]

    var Trade = [Trade]

    Return
    Calculate(
    Sum(table[Weekly Plan])

     ,table[Area] = CurrentArea
    ,table[Week No.] <=  CurrentWeek

    table [Trade] = Trade
    )

    Capture the current filters into variables and then ask it to sum the target column after adding some filters.