Forum Discussion
Working Days Between Two dates in two Tables
Here is another file that is simplified with the table and column names matching your examples so it should be easier for you to follow. I have also included step-by-step instructions of what to do to integrate this with your script (text in green font shown in the snip below). Below is a snip from the Advanced Editor view of Table2. Essentially you will copy/paste into your query and then make a couple of edits.
Thank you I do appreciate your help.
This looks extreamly complicated, im not sure I can get this to work withing my Current PBIX Report.
I know this is a Big Ask, Please may I have an Example PBIX File I can download to try and reverse engineer?
I would upload mine but it has alot of personal in formation etc
Here is another file that is simplified with the table and column names matching your examples so it should be easier for you to follow. I have also included step-by-step instructions of what to do to integrate this with your script (text in green font shown in the snip below). Below is a snip from the Advanced Editor view of Table2. Essentially you will copy/paste into your query and then make a couple of edits.
Thank you so so much this has helped massivley, Apologies on the novice Questions
You are very welcome! We have all been there. 🙂