Forum Discussion
Measure difference between 2 dates in 2 tables
Hello community members, I have a question and I can't find the solution myself... I have 2 tables: Table A ID_number Proposed_end_date 1 31-5-2021 2 31-1-2021 3 31-3-202...
Hello Anonymous
try this measure here. It should do the work
Measure = DATEDIFF(Max(B[Actual_end_date]),Max(A[Proposed_end_date]),DAY)If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello Anonymous
try this measure here. It should do the work
Measure = DATEDIFF(Max(B[Actual_end_date]),Max(A[Proposed_end_date]),DAY)
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi Jimmy,
Works perfect! Thanks for your help!
Cheers Sander