Forum Discussion
Solved
Cumulative Count Previous Year
https://imgur.com/akzvvqU Cumlative count is displaying great for this year. But how do I go about showing the previous year? You can see in the screenshot above I'm looking to compare 2 years, ...
This is your code:
Cum2 = TOTALYTD(CALCULATE(COUNT(IncidentInjury[id]));IncidentInjury[created_at];ALL(IncidentInjury))Cum3 = TOTALYTD(CALCULATE(COUNT(IncidentInjury[id]));SAMEPERIODLASTYEAR(IncidentInjury[created_at]);ALL(IncidentInjury))as seen here:
Please mark as solution if so, thumbs up for the effort would be great.
Kind regards, Steve.
stevedep
Memorable Member
Memorable MemberThis is your code:
Cum2 = TOTALYTD(CALCULATE(COUNT(IncidentInjury[id]));IncidentInjury[created_at];ALL(IncidentInjury))Cum3 = TOTALYTD(CALCULATE(COUNT(IncidentInjury[id]));SAMEPERIODLASTYEAR(IncidentInjury[created_at]);ALL(IncidentInjury))as seen here:
Please mark as solution if so, thumbs up for the effort would be great.
Kind regards, Steve.
Thanks Steve!
What's the filter/syntax to cut the data off at the MAX date? (For example, I want the line to stop at June)
