3 tables(datasets), how do you add working days to date sold?

[Anonymous]

I have the following tables in PowerBI Desktop.

**Sales Table**

Date sold | Product | item | address
24-11-2018 | socks | 02 | orlando 
26-11-2018 | socks | 02 | mexico df

**Calendar table**

Date | isWeekend | isHoliday | isWorkday
24-11-2018 | 1 |  0 | 0
25-11-2018 | 1 |  1 | 0
26-11-2018 | 0 |  0 | 1
27-11-2018 | 0 |  0 | 1

**Days to Deliver By Location table**

address | days to deliver in workdays
orlando |  4

I need to add a new column in "Sales Table" where i get the "Date to Deliver", which is the sum of "Date Sold" + Days to deliver". Now, the problem i have is that i can't / don't know how i can manage to add only the working days.

[Anonymous · Accepted solution]

This question was solved here https://stackoverflow.com/questions/53506369/using-mysql-or-powerbi-and-3-tablesdatasets-how-do-you-...