calculate duration of two Dates

[HassanAli123]

Hi,
     i have 2 dates columns. i want to calculate the "duration" of start date and end date and the format should be like "5 year and 4 months". how to do it in DAX
Thanks,

[v-yanjiang-msft]

Hi @HassanAli123 ,

Has your problem been solved by @jdbuchanan71 's solution? If yes, please consider accept it as the solution to help the other members find it more quickly. If not, please feel free to let me know.

Best Regards,
Community Support Team _ kalyj

[jdbuchanan71]

Here is one I was messing with that does just years and months.

Duration = 
VAR _Months = DATEDIFF ( 'Table'[Start Date], 'Table'[End Date], MONTH )
VAR _Years = INT ( DIVIDE ( _Months, 12 ) )
VAR _RemMonths = MOD ( _Months, 12 )
VAR _YearText = IF ( _Years = 0, BLANK(), IF ( _Years = 1, _Years & " year and ", _Years & " years and " ) )
VAR _MonthText = _RemMonths & IF ( _RemMonths = 1, " month", " months" )
RETURN 
_YearText & _MonthText

[mh2587]

Measure = 
VAR __daysinMonth = DAY(EOMONTH([Date1],0))
VAR __years = DATEDIFF([Date1],[Date2],YEAR) - 1
VAR __months = IF(MONTH([Date1])<MONTH([Date2]),MONTH([Date2])-MONTH([Date1]),12-MONTH([Date1])+MONTH([Date2])-1)
VAR __days = IF(DAY([Date1])<DAY([Date2]),DAY([Date2])-DAY([Date1]),DAY([Date2])+(__daysinMonth-DAY([Date1])))
RETURN __years & " year, " & __months & " months and " & __days & " days"
//Try this with your requirements

[mh2587]

https://community.powerbi.com/t5/Desktop/Calculating-the-difference-between-two-dates-in-Years-Month...

referring you to this link