Forum Discussion
Expressions that yield variant data-type cannot be used to define calculated columns.
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
Anonymous 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"
)
2 Replies
- bhanu_gautam
Super User
Anonymous 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"
)