Showing results for 
Search instead for 
Did you mean: 
Egemeny Frequent Visitor
Frequent Visitor

Identifying New Hires with a calculated column

Hi everyone,

I'm working on a HR dataset and i'd like to create a calculated column to identify new starters in the same month, so i can calculate New Hires this year and New Hires SPLY.

I found a .pbix file online. In this file new starters highlighted with '1' and that's exactly what i need. They used the following dax for this calculation.


isNewHire = IF(YEAR([date]) = YEAR ([HIREDATE]) && MONTH([DATE]) = MONTH ([HIREDATE]),1)


I can't do this with with my .pbix  and i need help with this.

Thank you all for in advance!




Community Support Team
Community Support Team

Re: Identifying New Hires with a calculated column

@Egemeny ,


Could you share more details about left (Still in business >6) and (Left the Business <6)? If possible, could you also share the expected result?


Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 243 members 2,995 guests
Please welcome our newest community members: