Forum Discussion
Gwhiz
Helper I
Helper Ineed help modifying this cumulative dax formula
I am having trouble getting this formula to reset every month as it doesn't go to 0 but when I have it reset each year it works fine: Business cumulative =
SUMX(
FILTER(
ALLSELECTED(...
GwhizHelper I
Helper Iparry2k I used that in the first formula in my post and you can see that the sum does not reset every month that way.
GwhizHelper I
Helper Iparry2k here is a replica of the pbix https://www.dropbox.com/s/ay6uqsw4e1ocdpe/cumulative%20business%20days.pbix?dl=0
Some of the dates got cut off but 2015 is a good year to look at.