Forum Discussion

_Amy_'s avatar
_Amy_
Icon for Helper I rankHelper I
4 years ago
Solved

DAX comparison operations

I have a DAX formula that calculates the number of employees who have departed in the last 12 months and it works well. I am just trying to add to the formula an additional filter where the 'departu...
Need Help
  • _Amy_'s avatar
    _Amy_
    4 years ago

    Thank you, I changed it around so the part of the formula that was causing the issue is now at the start of the formula and it works:

    "Departed Past 12 months", IF  ('All Employees'[Departure Flag] = 1 && [Termination Date]>=selectedDate12MonthsBefore && [Termination Date]<=selectedDate,1,0)) ,[Departed Past 12 months] = 1))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

_Amy_ , Try like

 

"Departed Past 12 months", IF([Termination Date]>=selectedDate12MonthsBefore && [Termination Date]<=selectedDate && 'All Employees'[Departure Flag] = 1 && [Departed Past 12 months] = 1,1,0)

_Amy_'s avatar
_Amy_
Icon for Helper I rankHelper I
4 years ago

Thank you, I tried that but it didn't work.

The "[Departed Past 12 months]" is the name of the measure I am creating here so I can't use it in the formula like that.