Forum Discussion
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...
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))
You put the condition without checking it.
In my opinion, you need to put your condition in If Function against the out of it
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))