Help

[Michalison]

I am creating a dashboard for absence reporting last week I had help from this community to create the following dax

rolling 6 months = CALCULATE(COUNT(Absence[Start Date]),DATESINPERIOD(Absence[Start Date],MAX(Absence[Start Date]),-6,MONTH))

This counts how many episdodes (not how many days) of absence someone has had over the last 6 months - I have now been asked by my employers can we have people who have had more than 3 episodes of absence in the last 6 months from todays date (ie system date) - I have no idea how to do this - any suggestions?  many thanks

[Michalison]

Tried it just comes up with blank table

[Anonymous · Accepted solution]

Hi Try this,

rolling 6 months = 

CALCULATE(COUNT(Absence[Start Date]),DATESINPERIOD(Absence[Start Date],today(),-6,MONTH))

and after on the filter panel you fix the value at >3 for this measure

[Michalison]

Thanks this works