Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
This question was solved here https://stackoverflow.com/questions/53506369/using-mysql-or-powerbi-and-3-tablesdatasets-how-do-you-...
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |