Modify Values

[dandreev]

I have a table with following numeric values:

	A		B		C
WN	112.00		256.00		198.00
TD	3.96		5.634615		4.506757
OD	4.00		5.530435		4.320175

How to get the following results?

	A		B		C
WN	112		256		198
TD	3.96		5.63		4.51
OD	4.0		5.5		4.3

The values need to be row WN =Whole Number, TD = Two Decimals, OD = One Decimal Value.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I suggest unpivotting the table like below, and write the measure like below.

Result: =
SWITCH (
SELECTEDVALUE ( Data[Category] ),
"WN", FORMAT ( SUM ( Data[Value] ), "#,##0" ),
"TD", FORMAT ( SUM ( Data[Value] ), "#,##0.00" ),
"OD", FORMAT ( SUM ( Data[Value] ), "#,##0.0" )
)

[dandreev]

Thank you Jihwan_Kim! 

[amitchandak]

@dandreev , You have to create a new column or measure for each one

example

A= Switch(True() ,

[Column 1] = "WN", round([A],0) ,

[Column 1] = "TD", round([A],2) ,

[Column 1] = "OD", round([A],1)

)