Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.