Forum Discussion
Helper IFilter on Cumulative YOY graph not working
Super User
Helper IThanks for taking a look at this. One thing i noticed was that on the file you shared, the current month's data is replicated across future months for the current Fiscal year (20-21). I couldn't figure out how to cut that off October on your code like you see in my original. Also, I've tried using DATESYTD function before to build this graph and didn't get the same result. What was the key here? was it just having that Dates table that you built?
- Ashish_Mathur
Hi,
You are welcome. You may modify my cumulative revenue measure with an IF statement. If the revenue is 0, then blank else my cumultive revenue measure. If you are unable to do it, post back.
- Mattbidev101
I tried replicating the changes you suggested in my original file but the data is not cumulative. what am i missing in these steps? Here is the file again with my attempt at your suggestions.
- Ashish_Mathur
Hi,
That takes me to a sign-in page.