Forum Discussion
Week calendar multi date table
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.
1 Reply
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-trend/ba-p/882970
