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