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 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
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |