Convert duration in days to Year month and day

[gancw1]

Is there a simple way to convert durations computed from the difference of 2 dates into years, months and days 

[Anonymous · Accepted 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

[amitchandak]

@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