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!!
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.