How to deal with multiple dates from multiple tables in Power BI

[Anonymous]

Hi,

I'm working with a large dataset for a company and I'm creating a report for a specific KPIs, I have many tables, each one is an excel extraction for a unique project and each table hase a Date column titled 'Date - Project1' for exemple, and each date column has a different Start and End date, when i try to visualise all the data from all table i have to make first a relation between Dates column, one way to do so is by creating a calender with hardcoded first and last date or calculating the minimum and maximum like the screenshot shows down below, -I've just replace the projects names with the iterations-

but in my case I might add continuously other project's table or remove others so I don't want to every time miss with code, is there any dynamic way to do this, and thank you in advance ^^

[amitchandak]

@Anonymous , Very similar approach I used in HR, Please find attached file

You can refer

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

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