Date difference between two data from different table

[DLM0830]

HI !

I am trying to get an interval between two date from different excel files. I have tried datediff with lookupvalue but all I can get are syntax. I can't even merge my tables since it has many to many relationship. Anyway, I have put a screen shot of one of my sheets.

[Anonymous]

HI @DLM0830,

I'd like to suggest you create a calendar table based on unique date value from those tables, then use calendar as bridge table to link original tables.

After these steps, you can try to create a measure to calculate datediff between different date fields.

BTW, you can try to use below measure formula if it works for your scenario.

Measure =
DATEDIFF (
    SELECTEDVALUE ( Table1[Order Date] ),
    SELECTEDVALUE ( Table2[Po Date] ),
    DAY
)

If above not help, can you please share some sample data or pbix file to test?

Regards,

Xiaoxin Sheng