Rounding off with 2 formats in one column

[romilv1]

Hi Folks,

I have one issue. There is one column that contains values in decimal places (upto 4 digits in after decimal). We need to column that brings rounding off values as well as % values.

See below:

As you can see actuals column the values are all whole number. The values 57 should show as 56.83%.  I have written a formula in Power Query that says if the label contains % then we need to convert the value to 2 decimal places (example 58.63%) else we can round off to 0 decimal places (see below)

As you can see the Amount.1 column shows correct value as desired for % column (i.e. Gross Profit %)

As you can see below the Amount.1 column has also converted the value for Non % value to 0.00 (see Amount column as well)

So the issue is that the Power Query formats/round-off properly for Non-Percentage values but we don't need 2 dp for Non % values

Ideal formatting would be:

Both the arrow marked should show values as 58.63% whilst rest of values should be as-is. The issue is to bring non % values as whole number (example: 362,709) which is fine but then it also converts % values as whole number.

Thanks

[danextian]

Hi @romilv1 ,

Use dyamic string formats (applies to explicit measures only ).

The second Sum of Value is a measure.

[romilv1]

Thanks but that is not what I am looking out for. The issue is showing 2 decimal for Percent column and 0 decimal places for Number column . You have mulltipled the % value by 100. In your example Sum of Value (second column) 0.95 should be 95.00 and 200.00 should be 200.