date difference from different tables without relationship

[Puneeth]

Hi all,

I have Date1 from table A and Date2 from table B.. 
i want to calculate measure as DATEDIFF(A[Date1],  B[Date2], Days])  
FYI Table A and Table B are not related (no relationship exists)

i'm not able to use the above measure.. is there any other way where i can achieve the result as per my scenario

Any help would be appreciable 
thanks

[v-piga-msft · Accepted solution]

Hi @Puneeth,

It seems that if we wnat to calculate the date difference from different tables, there should be a relationship between the tables.

You could create the index column for both of the tables in Query Editor and create the relationship between the tables.

Then you could try the formula below to create the calcualted column.

Column = DATEDIFF('Date1'[Date1],RELATED(Date2[Date2]),DAY)

Best  Regards,

Cherry