Forum Discussion
Solved
Date difference dax logics
Dear friends,
Here, I'm showcasing the quick snap for the kind reference for while calculating the Datedifference in dax level and excel sources.
I'm appling the dax logics for date comparesion same logics in excel also. but excel calculating fine. dax level shocasing something wrong.
Logic 1 = 6-16-2021 - 6-15-2023 = 23 excel
logic 2 = 6-16-2021 -6-15-2023 = 24 DAX power bi.
Kindly support team,
Regards,
Gokul
Gokul_G16 I hope this helps you!THANK YOU!!
DateMonth =DATEDIFF ( DATE ( 2021, 06, 16 ), DATE ( 2023, 06, 15 ), MONTH ) - 1
1 Reply
Gokul_G16 I hope this helps you!THANK YOU!!
DateMonth =DATEDIFF ( DATE ( 2021, 06, 16 ), DATE ( 2023, 06, 15 ), MONTH ) - 1