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.
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 |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |