Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I want calculate Date Difference between 2 different tables. I think I did but i have two problem.
1-) that but it gives wrong result when calculating same days.
I use this:
Regards,
Solved! Go to Solution.
Try this:
Measure = DATEDIFF(max('Detailed DED Analysis'[DocumentDate]),max(Miro[Fatura Tarihi]),DAY)
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @koray
Try this if there is a relationship based on the DocumentNumber between those 2 tabels:
Miro Tarih =
LOOKUPVALUE (
Miro[Fatura Tarihi],
Miro[DocumentNumber], Detailed DED Analysis[DocumentNumber]
)
- MAX ( Miro[DocumentNumber] )
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hello @VahidDM
Thank you for reply.
It did not happen. Or I did something wrong 😞
Hi @koray
Is there any relashionship between your tables?
Can you share a sample of your data?
Appreciate your Kudos!!
Each Document Number in Miro table has many dates, which onr do you want to use in the calculation?
Appreciate your Kudos!!
Try this:
Measure = DATEDIFF(max('Detailed DED Analysis'[DocumentDate]),max(Miro[Fatura Tarihi]),DAY)
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Thank you so much @VahidDM
Seems to be working fine. But I couldn't understand why it gives a different result in the crossed out one in the picture below.
Because of the different aggregation you set for that column (for e.g. Earlier) and the MAX formula you used in the measure.
Appreciate your Kudos!!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |