Forum Discussion
Cumulative base on 3 column
- 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.
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.