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(...
parry2k
Super User
Super UserGwhiz you should use less than equal to instead of greater than equal to
Opportunity[CreatedDate].[date]<=MAX(Opportunity[CreatedDate].[date])
Gwhizparry2k I used that in the first formula in my post and you can see that the sum does not reset every month that way.
- Gwhiz
parry2k 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.