Forum Discussion
AllanBerces
Post Prodigy
1 year agoCumulative 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
- 1 year ago
Hi AllanBerces
Try thisCumulative_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!
- 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.] <= CurrentWeektable [Trade] = Trade
)
Capture the current filters into variables and then ask it to sum the target column after adding some filters.
FBergamaschi
Super User
1 year agoYour question is unclear to me, can you specify better please giving details of the columns to use and show an example?
Thanks