Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to add a conditional column that shows "complete" when XYZ columns contain a value (0 included), and "not complete" when any of XYZ columns contains a blank cell (null).
I have added a conditional column as follows:
If [columnX] equals [null] then [not complete]
Else if [columnY] equals [null] then [not complete]
Else if [columnZ] equals [null] then [not complete]
Otherwise ["complete"]
The funny thing is that the conditional columns works as expected in the query editor but when I close&apply the query, it shows the error "cannot convert the value null to type text". How can I check if a cell that contains a number is blank if the value "null" is considered as a text type by the operator?
Any ideas will be greatly appreciated!
Thanks!
Hi @ovl,
Can you share the formula here please? Did this happen after you added the column?
Best Regards,
Dale
Hi Dale,
Thanks for quick reply!
Here is a screenshot of what I was trying to explain:
As you can see below, when I click "ok", the column is added and works as expected (in the query editor). However, when I close and apply the query, it shows me the error "we cannot convert the value null to type text" and the column is not added.
Thanks for your help!
Oriol
Hi,
I am trying to add a conditional column that shows "complete" when XYZ columns contain a value (0 included), and "not complete" when any of XYZ columns contains a blank cell (null).
I have added a conditional column as follows:
If [columnX] equals [null] then [not complete]
Else if [columnY] equals [null] then [not complete]
Else if [columnZ] equals [null] then [not complete]
Otherwise ["complete"]
The funny thing is that the conditional columns works as expected in the query editor but when I close&apply the query, it shows the error "cannot convert the value null to type text". How can I check if a cell that contains a number is blank if the value "null" is considered as a text type by the operator?
Any ideas will be greatly appreciated!
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |