Forum Discussion
Error_With_DATEDIF_ Excel_Vs_Power Bi
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 dat...
Hi Anonymous
Try this:
Years Passed =
QUOTIENT( TODAY() - 'Sheet1'[Start Date], 365.25)Hope that works for you
Paul
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.