How best connect calendar table with a Table with multiples Dates column

[romovaro]

Hi,

I have a Calendar() function generated table with all the dates between 2022 and 2029 . I also have the following table with multiple dates column for every phase.

In the calendat table I have a formula to identify "workday" or "weekend". 

Contract Signature Date should be the Min Date for every "life product circle"

Right now I have a relationship date - Contract SIgnature date and the Workday filter is "working" but not sure for all steps. I see some visuals not showing as expected if selecting workday only.

WHich is the best approach to for the connector?

Thanks,

[amitchandak · Accepted solution]

@romovaro , if you want to connect with multiple dates make sure none of them have a timestamp. Join them with date of date table. One join will be inactive you can activate using userelationship

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...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

In case you need workday diff, you can use networkdays

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c