Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |