Minor Change to a Formula - One Decimal Place for Date in Years/Months format

[duesouth]

With help from this community, I've been working out how to change reading ages for pupils in a school into a years months format.  This is now done and working.  My one last thing - the icing on the cake - is that the formula below gives me a result in the format 12 Years 9.1764705882353 Months for our year 7 cohort.  Can the formula below be changed so that I can set to 1 decimal place?    The format of the column in Power BI is text - if I change it to a number I then get an error...

Reading Age Averaged =

var year1= INT('Reading Ages'[Average RA]/12)

var month1='Reading Ages'[Average RA]- year1*12

return

SWITCH( TRUE(),

    'Reading Ages'[Average RA]<12,"0 Year "& 'Reading Ages'[Average RA] & " Months",

    'Reading Ages'[Average RA]=12,"1 Year "& "0 Months",

    year1& " Years " & month1 & " Months")

Thanks in advance for any help!

[aduguid · Accepted solution]

Reading Age Averaged =
VAR year1 = INT('Reading Ages'[Average RA] / 12)
VAR month1 = 'Reading Ages'[Average RA] - year1 * 12
RETURN
    SWITCH(
        TRUE(),
        'Reading Ages'[Average RA] < 12, "0 Year " & FORMAT('Reading Ages'[Average RA], "0.0") & " Months",
        'Reading Ages'[Average RA] = 12, "1 Year 0 Months",
        year1 & " Years " & FORMAT(month1, "0.0") & " Months"
    )

[rajendraongole1]

Hi @duesouth - Can you try the below updated measure:

Reading Age Averaged =
var year1 = INT('Reading Ages'[Average RA] / 12)
var month1 = ROUND('Reading Ages'[Average RA] - year1 * 12, 1)
return
SWITCH(
TRUE(),
'Reading Ages'[Average RA] < 12, "0 Year " & month1 & " Months",
'Reading Ages'[Average RA] = 12, "1 Year 0 Months",
year1 & " Years " & month1 & " Months"
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[duesouth]

@aduguid @rajendraongole1 Thank you so much for your help - much appreciated!