Summarising two dates from the same data

[petecousins]

Im trying to compare number of users who moved into a building and moved out of a building. Ive set up monthly bins so the dates below show as months. I dont want the analysis to show any relation between these two dates, just the overall number who moved out vs moved in in each month. ive created a 'date' table to give a consistant axis but of course i cant link this to both these fields as one link becomes inactive.

[amitchandak · Accepted solution]

@petecousins , You can join two tables with same date table and one Join will be inactive that you can activate using userealtionship

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

example

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

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.