Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Difference between 2 different tables

I have 2 date fields from 2 different tables. I want to find the date difference between the date fields. So, I created a measure as follows:   Measure = DATEDIFF ( SELECTEDVALUE ( 'Table 1'[Start_...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    You can try this calculate column :

     

    Column = DATEDIFF(MAXX(RELATEDTABLE(Table4),'Table4'[Start Date]),'Table5'[End Date],DAY)
     
    Here is the demo, please try it:(refer table4 and table5)
     
    Best Regards,
    Yingjie Li
     
    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Anonymous ,

You can try this calculate column :

 

Column = DATEDIFF(MAXX(RELATEDTABLE(Table4),'Table4'[Start Date]),'Table5'[End Date],DAY)
 
Here is the demo, please try it:(refer table4 and table5)
 
Best Regards,
Yingjie Li
 
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

rnimmala's avatar
rnimmala
Frequent Visitor
2 years ago

Excellent solution.  Thank you. !!!