Expressions that yield variant data-type cannot be used to define calculated columns.

[jeongkim]

Hi,

earfcnDL value refererred is Whole number format.

So I wrote the code as number, this not working. 

But the other TEST PBI has enrfcnDL is Text format.

So I wrote the code as text values, this working

[bhanu_gautam · Accepted solution]

@jeongkim Try using Format

Max Power Hz =
SWITCH(
TRUE(),
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "2500", "850 Mhz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "1350", "1.8 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "275", "2.1 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "2850", "2.6 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "3200", "2.6 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "1550", "1.8 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "1694", "1.8 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "1650", "1.8 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "3743", "900 Mhz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "450", "2.1 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "475", "2.1 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "2600", "850 Mhz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "100", "2.1 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "2050", "2.6 Ghz",
FORMAT('LNCEL_FDD'[earfcnDL], "0") = "3050", "2.6 Ghz"
)

[jeongkim]

It worked, thank you