Forum Discussion

Varan_15's avatar
Varan_15
Helper III
2 years ago
Solved

Calculate Cumulative Sum

Hi All,

 

i have connected calander table and dim customer balance table now i would like to create monthly account level cumulative sum based on balance measure.

 

YearMonthCUSTTOMER IDACCOUNT_NOMeasure[Balance]Cumulative sum
2024March2020111111116000 
2024April20201111111130009000
2024May202011111111200011000
2024June202011111111100012000
2024July20201111111150012500

 

need to create month on month sum of balance (cumulative sum) expected result kindly help on this 

 

Thanks in advance