Create data agnostic date field

[daveedd]

Afternoon everyone,

My dataset has several date fields which I want to lay out on the same visuals like below.

Trouble is because the date field used there is tied to the opened date the closed number is incorrect.  These are the correct numbers I should see

So what I'm looking for is a way to put a date field on a visual and drag measures based on various date fields into it.  Any ideas?

[amitchandak · Accepted solution]

@daveedd , Have tried inactive join and userelationship

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

[daveedd]

@amitchandak That's great thanks a lot! 

Quick follow up, I'm working with date-time fields, is there a cleaner solution than splitting it into separate date and time fields to make this work, or is that what you would do?

And is it possible to do the same with hours of the day (0-23) on the same metrics, or would we be looking at multiple?