Error_With_DATEDIF_ Excel_Vs_Power Bi

[Anonymous]

Dear Team,

We could see the result of DATEDIF is showing the different result compare to Excel Vs Power Bi.

To test you can start date ( Date -1 ) range from 6-Jan-96 to 18-Jun-96 and end date for all the rage is Today (Date - 2).

[Anonymous]

Thank you for work around solution , but it again impact during leaf year and all. 

Microsoft suppose to be fix this issues of DAX formula, as they created this DAX formula for the same purpose. but its not giving the expacted result.

[PaulMac]

Hi @Anonymous 
Try this:

Years Passed = 
QUOTIENT( TODAY() - 'Sheet1'[Start Date], 365.25)

Hope that works for you 

Paul

[Anonymous]

Thank you for work around solution , but it again impact during leaf year and all. 

Microsoft suppose to be fix this issues of DAX formula, as they created this DAX formula for the same purpose. but its not giving the expacted result.