Forum Discussion
Date Difference between 2 different tables
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: ...
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!!
VahidDM
Super User
Super UserTry 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!!
VahidDM Yes you are right. Thank you so much 🙂
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.- VahidDM
Anonymous
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!!