count multiple conditions
1 Topic
How to countif with multiple conditions across table
Hi, Please help me find out the following Here is my current DAX EX1 = COUNTROWS(FILTER(Terminate,CONTAINS('Hire 2022','Hire 2022'[ID],Terminate[ID]))) But another condition that need to be filtered is count if the effective date of Terminate is after the effective date of Hire 2022 Please let me know if it needs data support. Thank you!Solved858Views0likes3Comments