Date Difference- Date column in 2 different columns

Hi NChamroo 

Thanks for the reply from foodd .

NChamroo , I created a simple test for your reference.

My sample:

no relationship between two tables:

Create a measure as follows

Measure = DATEDIFF(MAX(Table1[StartTime]), MAX(Table2[EndTime]), DAY)

Output:

If this doesn't solve your problem, please provide some sample data and the expected results based on the sample data. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.