Count Year by year

[philip_radovich]

Hi,

I am trying to create a line chart with two measures that will show the current year and the previous year only. My only dimension is a field MonthYr. The current expression I am using to show all of the data is Count({<MissionStatusSK ={1347}>}Distinct InjurySK). I am needing to show only the injuries that have a status of 1347 for the current year and the previous year. I am having trouble with figuring out how to modify my expression to only include dates that fit the criteria. Any help would be greatly appreciated.

Thanks,

Phil Radovich

[dplr-rn]

Have you created a master calendar?

If you have use set analysis to achive the same. e.g.

Year={"$(=Year(Max(OrderDate)))","$(=Year(Max(OrderDate))-1)"}

if you dont have a master calendar would recommend creating one