Forum Discussion
Calculating dates between comparing dates from 3 tables
Debbie_Montique,
Please help to share sample data of the three tables and post expected result based on sample data here.
Regards,
Lydia
Hello Lydia,
Below is what I have so far, notice that the inbound serial number (left table) was received on 5/17/2018, and we see that it was shipped out on 5/29/2018 (middle table). Easy enough to see that the cycle time would be 7 working days (Sat-Sun and holiday excluded). However, if it were a scrapped unit, it would appear in the far right table (currently you see empty in the screenshot). What I'm having a problem with is how to calculate the # of working days from the inbound to either the shipped table (center table) or the scrapped table (far right table).
Thank you so much for your help!
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,
LydiaThank you! I will try to figure it out.