Solved: Measure difference between 2 dates in 2 tables

Anonymous · ‎03-19-2021

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-2021
4	30-4-2021
5	31-1-2021

Table B

ID_number	Actual_end_date
1	5-6-2021
2	31-1-2021
3	14-2-2021
4	5-5-2021
5	28-1-2021

I would like to know how many days difference there is between the proposed end date and the actual end date.
Does anyone know how to make the correct measure?

Hope to hear soon from you.

Best regards, Sander

Jimmy801 · ‎03-19-2021

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

View solution in original post

Jimmy801 · ‎03-19-2021

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