Forum Discussion

Michalison's avatar
Michalison
Helper II
4 years ago
Solved

Help

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
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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