UNIFY DATE COLUMNS

[Syndicate_Admin]

Good morning

I come to your knowledge to know if this is possible:

* I have in my model two date columns, with each of them I perform calculations.

* When I am going to add these calculations to a new extent, the result is not correct, I assume that it is because you have filters of the different columns.

* As a solution, I think you could unify these two columns into one, as a kind of "master date column" so that the filter is one, so I assume you could create a new date column, but I do not know how you could do it or, if you can create some relationship between the columns, Thanks a lot.

Thanks a lot.

[amitchandak · Accepted solution]

@Syndicate_Admin , Join with a same date table and one active and another inactive join , create a measure using userelationship to activate the inactive relationship

examples

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...