Counting Attrition Data

[Anonymous]

Hello, 

I am attempting to make a trend ahowing attrition data for a rolling 12 month period. My data set includes a "Termination Date" field with the date an employee left the company, and is blank if they are currently still with the company. I had the idea to make a flag for terminations that occurred in each quarter of the year. My idea was to make a flag of "1" if they were terminated during that quarter or a 0 if they were not, and then do a count of the flags to show the number of terminations each quarter. I am trying to use the following expression in Power Query, but it is not calculating like I want and is flagging those with earlier termination dates than just within that quarter:

Q1 2022 Termination = IF(ISBLANK('HCData'[Termination Date]),0,IF('HCData'[Termination Date] >= 4/1/2022,1,0))
Does anyone have any guidance as to what my syntax error is here? Thanks in advance!!

[Vera_33 · Accepted solution]

Hi @Anonymous 

If it is Q1, should be >= 20220101 and <20220401, right? And you want to use Power Query? The above should be DAX...Power Query is like this, file attached

[Anonymous]

Thank you Vera!! This ssems to have done the trick. I really appreciate the help!