Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am having trouble creating a calculated column, where I search another column for values < 2000.
IF < 2000, then it shall return "Home" and IF > 2000, then "Out".
I have tried something like this
_Out_Home =
IF(Value('DM_Employee'[PersiumOrgID]) < 2000, "Home", "Out")
The column consists of non unique IDs in text format, which is why I use the Value function.
When i do this it says: " Cannot convert value '' of type Text to type Number. "
I have also tried this:
Solved! Go to Solution.
Hi @Gustav_Juel_Hal ,
I test the data your provided ,run successful(see the below).
Cannot convert value '' of type Text to type Number: It might be because one of the rows contain blank value or non numberic value. In query editor, try filtering each column for a non numeric value.
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value:refer :
Wish it is helpful for you!
Best Regards
Lucien
Hi @Gustav_Juel_Hal ,
I test the data your provided ,run successful(see the below).
Cannot convert value '' of type Text to type Number: It might be because one of the rows contain blank value or non numberic value. In query editor, try filtering each column for a non numeric value.
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value:refer :
Wish it is helpful for you!
Best Regards
Lucien
@Gustav_Juel_Hal , In case you want to create a new column
_Out_Home =
IF('DM_Employee'[PersiumOrgID] < 2000, "Home", "Out")
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |