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 have blanks in my column in the query and I am trying top use it in a conditional column.
What would the test be, it is not null as there is not a null in the column only a blank cell.
Thanks
C
Solved! Go to Solution.
@Anonymous,
You may use code below.
if Text.Trim([Column1]) = "" then
'null' may not work in the wizard unless the value is missing. "blank" cells in Excel files may have the apostrophe character -- so use **** ' **** (exclude asterisks/spaces) in the wizard
Here's what you can do:
Create a "Custom column" where custom colum formula =""
Then, reference the newly created, totally blank column in your conditional column setup and "Voila!"
Hope this helps!
Namaste.
@Anonymous wrote:Hi,
I have blanks in my column in the query and I am trying top use it in a conditional column.
What would the test be, it is not null as there is not a null in the column only a blank cell.
Thank
@Anonymous,
You may use code below.
if Text.Trim([Column1]) = "" then
Thanks Sam, will try that. outr of curiosity how would you reference th blank cell when using the conditgional column wizrd in Power Query
I'm interested in how to do this via the Wizard as well
Use "null" in the wizard
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |