Forum Discussion

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

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