Forum Discussion

DanielHolland's avatar
DanielHolland
Frequent Visitor
4 years ago
Solved

Working Days Between Two dates in two Tables

Hello Guys,    I have two Tables, Table 1 contains an "Open Date" ,  Table 2 Contains "Escalated Date"     I would like to calculate the workings days which have passed between the "Open Date" a...
Need Help
Tips and Tricks
  • jennratten's avatar
    jennratten
    4 years ago

    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.

     

     

DanielHolland's avatar
DanielHolland
Frequent Visitor
4 years ago

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