Forum Discussion
kjartank
Helper II
Helper IIProblem with conditional column
Hi.
I have a problem making Conditional Columns work.
Have a column with values from 0-100 and some blanks. I just want all the rows that contain a number to have text and the blanks to be empty. PowerBI won't accept making a null into a null somehow. Is there a workaround?
Thanks in advance
The cause of the problem is that you test the values if they are > 0, which won't work for nulls.
Options:
- Test if the value = null
- Test if the value <> null
- Test if the value is a number (via "Add Custom Column", not "Add Conditional Colum")
= if [Satisfaction Score] = null then null else "String" = if [Satisfaction Score] <> null then "String" else null = if [Satisfaction Score] is number then "String" else null
13 Replies
kjartankI'm trying with the conditional column tool.
It just won't accept a blank as a blank.
