Forum Discussion

midoban's avatar
midoban
New Member
3 years ago

Cumulative Spend

Hi I need to have a cumulative spend column in power bi but using different filters   Can someone help me on this one?      
Need Help
midoban's avatar
midoban
New Member
3 years ago

hi amit,

 

here's a sample data in excel. same thing i want to show in power bi

 

amitchandak's avatar
amitchandak
Super User
3 years ago

midoban , with help from window function

 

Cumm Based on supplier = CALCULATE([Spend], Window(1,ABS,0,REL, ALLSELECTED('Table'[supplier]),ORDERBY('Table'[Brand],asc)))

 

or
Cumm Based on supplier = CALCULATE([Spend], Window(1,ABS,0,REL, ALLSELECTED('Table'[supplier],'Table'[Brand]),ORDERBY('Table'[Brand],asc),,partitionBy('Table'[Brand])))