Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
96 | |
85 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |