power bi dax formula Get days, months, and years between dates

[Suhel_Ansari]

Hi DAX Expert,

I need the DAX formula to calcuate the Year , Months and Days between the 2 given dates as seen in the following screen print, however as seen I am not getting the required output, Please assist with the correct formula. Thanks

Regards

Suhel

[Suhel_Ansari]

@amitchandak  , @v-yalanwu-msft  , @v-kelly-msft , please assit. Thanks

[amitchandak · Accepted solution]

@Suhel_Ansari , One of the way id have diff days and convert into month using 365 day and 30 days logic

new column =

var _diff = datediff([registration Date], [date of last known distance], day)

return

quotient(_diff , 365) & " Years " & quotient(mod(_diff , 365) ,30) & " Months "  & mod(mod(_diff , 365) ,30) 

[Suhel_Ansari]

@amitchandak  , It partially working The year and Month are correct however Days are calcualting wrong as shown in  attached screen print. Thanks