Forum Discussion
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_...
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
If you just want the number of days, then you can just subtract the two dates from one another and multiply by 1.0. Are the two tables related to one another and is it 1:1 or 1:many or ? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490