Forum Discussion
Solved
Cumulative Count Previous Year
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, cumulatively. (This YTD, and last year entirely)
CUMULATIVE = CALCULATE(
COUNT ( IncidentInjury[id] ),
FILTER (
ALLSELECTED ( IncidentInjury ),
IncidentInjury[created_at] <= MAX ('IncidentInjury'[created_at] )
))
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.
5 Replies
- lbendlin
Super User
SAMEPERIODLASTYEAR() gives you the entire previous year's date range. That is somewhat unexpected, but it perfectly fits what you want (however questionable the reasoning behind that is).
- stevedep
Memorable Member
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.
