topic Re: Help in DAX Commands and Tips

Help

Michalison — Thu, 19 May 2022 09:33:23 GMT

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

Re: Help

Anonymous — Thu, 19 May 2022 11:33:09 GMT

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

Re: Help

Michalison — Thu, 19 May 2022 12:23:28 GMT

Tried it just comes up with blank table

Re: Help

Michalison — Tue, 24 May 2022 09:05:59 GMT

Thanks this works