Date difference dax logics

[Gokul_G16]

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

[Mahesh0016 · Accepted solution]

@Gokul_G16 I hope this helps you!THANK YOU!!

DateMonth =

DATEDIFF ( DATE ( 2021, 06, 16 ), DATE ( 2023, 06, 15 ), MONTH ) - 1