Forum Discussion
Calculating dates between comparing dates from 3 tables
I have 3 different tables where I'm trying to calculate cycle time. All 3 tables have the serial number associated with the part as the relationship. First table is inbound ...unit serial number...
Debbie_Montique,
Do you create relationships among these tables? You can create calculated columns in the first table to bring date columns of second table and third table into the first table, then calculate working days following the guide in the similar threads below.
https://community.powerbi.com/t5/Desktop/Number-of-days-between-two-dates-but-only-counting-work-business/td-p/158820
http://community.powerbi.com/t5/Desktop/Number-of-working-days/m-p/256119
Regards,
Lydia
Thank you! I will try to figure it out.