Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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).
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.
Hi @raghuveerhegde
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.
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |