Forum Discussion
Helper IFilter on Cumulative YOY graph not working
Super UserHi,
That takes me to a sign-in page.
Helper I- Ashish_Mathur
Hi,
I have edited the formula in my solution file i shared with you earlier. Download the revised file from here.
Hope this helps.
- Mattbidev101
I appreciate you sticking with me! However it's still not working rolling up cumulative. this dax that you shared:
Cumulative revenue1 = IF(ISBLANK([Revenue]),BLANK(),CALCULATE([Revenue],DATESYTD(Dates[Date],"30/6")))and the dax i used:Cumulative revenue1 = IF([Revenue] = 0,"",CALCULATE([Revenue],DATESYTD(Dates[Date],"30/6")))should function the exact same way. I'm missing something else that you are doing in your file to make this work. Can you see what I'm missing in the file I shared? When you shared your solution the first time, i tried to find everything that you did but I must have missed something important. - Ashish_Mathur
Hi,
Why can you not just apply my formula? I have spent quite some time in framing that solution and would not like to devote any more time in identifying the problem in your file. Hope you understand. Thank you.
- Mattbidev101
I did apply that formula to make sure. It doesn't work. Is there something else that you did besides just that function?
- Ashish_Mathur
No, i did not.
- Mattbidev101
Ok thanks for trying. You've given me some stuff to look at least. If i manage to solve it I'll publish something for anyone interested.
- Ashish_Mathur
Thank you for your understanding. I would have looked at your file had i already not spent enough time in framing the original solution. Furthermore, in the file that i shared with you, it is working absolutely fine. Compare the Calendar table and the relationships.
- Mattbidev101
I will thanks