Creating a relationship with two date columns on one table

[Anonymous]

Hi All, 

I have a table with two date columns, forecastdate and hiredate for employees. I want to be able to join both dates to my date table so i can show:

1) The forecasted amounts for the employee for a given month

2) the number of employees set to start for a given month

Is this possible?

Thanks!

[amitchandak · Accepted solution]

@Anonymous , if you want the same filter to work on both dates. Join those with a date table. Active/Inactive join will be created. Use userelation in measure for date of your choice

REfer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

Awesome! Thanks for the article. This seems like it will work perfectly.