Forum Discussion

Pmorg73's avatar
Pmorg73
Post Patron
6 years ago

Cumulative Summ issue

Hi everyone   I have a cumulative sum issue that I can not fathom.   See the image of my page, I have pasted the equations in to a text box so that they can be seen. I created a cumulative sum fo...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

try

 

Cummalative ytd = TOTALYTD(sum(Sales[Sales Amount]),filter(all(Sales[Sales Date]),Sales[Sales Date]<=maxx('Date',('Date'[Date Filer]))),"3/31")
	Cummalative lytd = TOTALYTD(sum(Sales[Sales Amount]),filter(all(Sales[Sales Date]),Sales[Sales Date]<=maxx('Date',DATEADD('Date'[Date Filer],-1,YEAR))),"3/31")

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

  • Pmorg73's avatar
    Pmorg73
    Post Patron
    6 years ago

    This does not work......

     

    Does it need a slicer to select the year?

    • Pmorg73's avatar
      Pmorg73
      Post Patron
      6 years ago

      The measure you have suggested are with the titles as you wrote them. They do not accumulate the totals?