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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    midoban , Try if new Window function can help

     

    Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • 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])))