Forum Discussion

spb's avatar
spb
Frequent Visitor
4 years ago

Calculate days between 2 columns in different table

Looking to calculate the difference in the 2 dates.   Table1 'ID' 'Late Finish date' 1      10 May 22   Table 2 'ID' 'Early Finish Date' 1      20 May 22   Answer - 10 days. To be included...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

If both tables have one ID per row, why not merge them in the query editor. Finding the difference between the two columns in same table can be done easily with a power query or DAX column.

 

Pat

 

spb's avatar
spb
Frequent Visitor
4 years ago

Thanks mahoneypat.

I successfully merged the extra column into one of the existing tables and then used datddiff as suggested,  which produced a result.

However, when created a table visualisation I noticed I get multiple results for the same ID. This is due to the fact that updated data is added every reporting month to the table with the same ID (theres a reporting month field in one of the tables too). How do I calculate the difference in early start and early finish for the most recent month only to show in a table visualiation?

Hopefully Ive explained this ok.

Thanks for insight.