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...
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

Michalison's avatar
Michalison
Helper II
4 years ago

Tried it just comes up with blank table