Forum Discussion

Puneeth's avatar
Puneeth
Frequent Visitor
7 years ago
Solved

date difference from different tables without relationship

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

General Comment
Need Help
Show and Tell
Tutorial Requests
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    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