Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Syndicate_Admin
Administrator
Administrator

UNIFY DATE COLUMNS

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.

AndresPizano_0-1672410866126.pngAndresPizano_1-1672410888503.png

* 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.

AndresPizano_3-1672410964975.png

* 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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

1 REPLY 1
amitchandak
Super User
Super User

@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...

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.