How to add the decimal in the measure (Switch True) , which catches either A measure or B Measure

[naoyixue1]

Hey there,

I created below measure to catch Weekly Ending Inventory or WOS based on the selection. Right now, I want to add one decimal into the WOS calculation but still don't impact the ending inventory calculation. I tried fixed and round function, but it doesn't work. Does anyone know how to handle that? Thanks.

[v-yanjiang-msft · Accepted solution]

Hi @naoyixue1 ,

Has your problem been solved? 

If the WOS is of number type, you can directly change the number of decimal places in the Format pane.

If the WOS is of text type, you can use FORMAT function as @lbendlin mentioned like this:

Measure = FORMAT([A],"0.0000")

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[lbendlin]

You will likely need to treat both outputs as text, and then use FORMAT() to get to your decimals.  Or you can consider using Calculation Groups.