Week calendar multi date table

[gugaDe]

I am trying to create a powerBi to calculate and create visuals to compare planned work, start/finish date and time, against the actual start date/time, and the actual finish date/time..management prefers a gnatt chart look for the visusal.

Do I need 3 calendar tabels? planned, start, finish? I tried to screen shot my excel sheet below

I have the columns planned start,fininsh, duration input by one group, then column start date and time input by second group, then finish date, time, duration input by third group.

[amitchandak]

@gugaDe , if you same month based on each date a single table with Active inactive joins and userelationship can help

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

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