Is there a simple way to convert durations computed from the difference of 2 dates into years, months and days
Solved! Go to Solution.
Hi @gancw1 ,
Please check the soultion in this post.
Solved: DAX to Convert days to Years,months & days - Microsoft Power BI Community
Best Regards,
Jay
Hi @gancw1 ,
Please check the soultion in this post.
Solved: DAX to Convert days to Years,months & days - Microsoft Power BI Community
Best Regards,
Jay
@gancw1 , You have convery
In power Query a new column diff
= [Duration1] - [Duraion 2]
Year=
Duaration.Days([Diff])/365.25
In this manner you have to calculate
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
50 | |
48 |
User | Count |
---|---|
163 | |
85 | |
76 | |
68 | |
67 |