Add text within calculation measure

[Chainfire74]

Hi,

This calculation gives me an average number, but is it possiblefor me to add the word 'Years' after the calculation so it is in one data card?

Average Tenure of Leavers =

CALCULATE(AVERAGE(Leavers3[Years Service]))

Thanks

[MahyarTF]

Hi,

Use this Dax Measure :

format(CALCULATE(AVERAGE(Leavers3[Years Service])), "#Year#$#,0.00")

[AntonioM]

You can use CONCATENATE

CONCATENATE ( CALCULATE ( AVERAGE ( Leavers3[Years Service] ) ), " years" ) 

[Chainfire74]

Thanks. When I do this, it does work - but I'm unable to change the decimal places. Any ideas? 

[AntonioM · Accepted solution]

You would need to FORMAT the number before it's joined.

CONCATENATE ( 
    FORMAT ( 
        CALCULATE ( 
             AVERAGE ( Leavers3[Years Service] ) 
        ),
        "0.00"
    ),
   " years" 
) 

 There are different options instead of "0.00", you can find them all here 

[Chainfire74]

Perfect, thank you. That worked!