Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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.

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable
1 REPLY 1
Anonymous
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.