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

[v-henryk-mstf]

Hi @Michalison ,

Can you provide the relevant test data, so that I can answer for you as soon as possible.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry

[Michalison]

No that does not work - I need it to list on a table the name and how many episodes of absence they have had in the last six months if they have had more than 3 episodes I count them by the start date of the sickness period not the staff ID

[amitchandak]

@Michalison , Assume you have employee id and the above measure

countx(Values(Absence[Employee ID]) , if([rolling 6 months]> 0, [Employee ID], blank() ) )