Converting Number to Years and Months

[User57639205]

Is it possible to use a measure or similar to convert total years number value to months and dates?

I have a table showing max amount of days, ive created a measure to convert this to years but ideally would like it to show as 1 Year 2 months 5 Years 6 months etc. Is this possible?

[lbendlin]

That will only make sense if you can provide the start date as well.

[Greg_Deckler · Accepted solution]

@User57639205 Maybe this?

Measure 2 = 
    VAR __Days = SUM('Table'[Column1])
    VAR __Year = TRUNC( DIVIDE( __Days, 365 ) )
    VAR __Months = TRUNC( MOD( __Days, 365 ) / 30 )
    VAR __Result = __Year & " Years " & __Months & " Months"
RETURN
    __Result

[User57639205]

Thanks you, this has helped so much 😀