Forum Discussion

merath01's avatar
merath01
Regular Visitor
6 years ago

Create a formula for cumulative total

Hello, I am trying to create a measure (or column) that calculates the rolling cumulative sales in a linear format for a table or matrix.  I know the sales and create a formula for the Cumulative Sa...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

You may download my solution file from here.

Hope this helps.

  • merath01's avatar
    merath01
    Regular Visitor
    6 years ago

    Thanks Ashish, but I cannot open the enclosure.  We are working off an older version of Power BI.

    • edhans's avatar
      edhans
      Icon for Community Champion rankCommunity Champion
      6 years ago

      merath01 any plans to share data that we can work with? My measure works with the data you provided me. I'd share my PBIX file but it is the same as Ashish_Mathur I'm sure, we are both on the latest versions of Power BI.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      What problem do you face?

      • merath01's avatar
        merath01
        Regular Visitor
        6 years ago

        Thank you all for your suggestions.  The problem still exists when moving the formula over to the real data.  The starting number for week one is not 1/13 of the total  for 13 weeks.  I think it is because the real data has more than 1 quarter of data.  

         

        I would like to share the real data, but it is confidential and I cannot share outside of my organization.

         

        Again thanks for your assistance.