Remove Decimals when using Format function

[ArchStanton]

Hi,

I have the following code which works but i'm getting 13 decimal places after the figure. I can't round anything down because the values are in Text due to the code I've used below.

Avg Case Length Months = 
                FORMAT(
                    AVERAGE('Cases'[Case Length (Adj)]),
                    "0") / 12 & " Mths"

Any ideas how i limit this just to 1 decimal point?

Thanks

[PijushRoy · Accepted solution]

Hi @ArchStanton 

Use try to use below DAX

Avg Case Length Months = 
                FORMAT(
                    AVERAGE('Cases'[Case Length (Adj)])/12,
                    "0") & " Mths"

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[ArchStanton]

Many thanks!! 😁