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.
I created a new column in Power Query by extracting "Text Before Delimiter". During my audit, there is a field within the column that I would like to update: "NULL" = [BLANK]. How would we be able to do that in Power Query? Below is sample data: Table 1 = Current Output / Table 2 = Expected Output.
(Table 1 = Current Output)
Labels | Labels Bucket |
NULL | NULL |
1,2 | 1 |
2,3,4 | 2 |
15,99,2000 | 15 |
(Table 2 = Expected Output)
Labels | Labels Bucket |
NULL | |
1,2 | 1 |
2,3,4 | 2 |
15,99,2000 | 15 |
Any advice is greatly appreciated.
Solved! Go to Solution.
@amitchandak Thank you for your support. I tried your suggestion but could not figure out how to add the command. After playing around with the column, "REPLACE VALUE" worked great.
Once again, thanks for your support!
@win_anthony , Try a new column
try one of the two
=Text.Replace("Null", null)
=Text.Replace("Null", "")
@amitchandak Thank you for your support. I tried your suggestion but could not figure out how to add the command. After playing around with the column, "REPLACE VALUE" worked great.
Once again, thanks for your support!
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 |
---|---|
102 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |