Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 date for all the rage is Today (Date - 2).

 

 

 

General Comment
Interesting Links
Need Help

3 Replies

  • PaulMac's avatar
    PaulMac
    Helper IV
    2 years ago

    Hi Anonymous 
    Try this:

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

    Hope that works for you 

    Paul

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.