CALCULATED COLUMN CUSTOMISATION

[srkase]

Hi

I have a table name prod_cable.  Column Name : minorgroup

Minor group has the following values. 4" Set , 5" Set, 6" set, etc...

I wanted to create a calculated column.

prod_Cable[minorgroup] = 4"set , then value is 18

prod_Cable[minorgroup]=5" set, then vlaue is 20... etc

Kindly advise.

Regards

SRK

[V-pazhen-msft · Accepted solution]

@srkase 

With my test the issue is the " sign of 4" Set, power bi cannot read "" quotes properly when your cell includes ". To workaround this issue for now, you may replace 4" Set to 4' Set, basically you can use any sign other than ".

Then use the Switch formula from above replace the quote parts to "4' Set", "5' Set", etc.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[az38]

Hi @srkase 

try to create a SWITCH column like

Column = 
SWITCH(prod_Cable[minorgroup],
"4""set", 18,
"5""set", 20,
"Other"
)

[srkase]

am getting the following error..

[v-amarsh]

Hi,

Looks like there is an issue with quotes used.

Please try any one of the below 

Column =
SWITCH(prod_Cable[minorgroup],
"4"set", 18,
"5"set", 20,
"Other"
)

OR using NESTED IF Condition:

Column =

IF(

prod_Cable[minorgroup] = "4"set",18,

prod_Cable[minorgroup] = "4"set",20,

"Other"

)

Thanks

[Greg_Deckler]

Seems like maybe:

Column =
  SWITCH('prod_cable'[minorgroup],
    "4"" Set",18,
    "5"" Set",20,
    ...
  )