Forum Discussion
Anonymous
2 years agoNot applicable
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...
PaulMac
Helper IV
2 years agoHi Anonymous
Try this:
Years Passed =
QUOTIENT( TODAY() - 'Sheet1'[Start Date], 365.25)Hope that works for you
Paul