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
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.

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.