Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have created a sample data in which column Id has values like underscore (_), (null), (blank) etc. (refer rows 5 to 8 in attached file).
I understand there is an option "Remove Empty" which removes blank rows. In this case, row no. 5 will be removed. To remove the other unwanted rows, I will have to replace each of those values with a blank row and then use above option.
But when I select the column Id and navigate to Remove Rows -> Remove Blank Rows, none of the rows are removed.
How does the Remove Blank Rows option work?
Please explain using this same example and sample data.
Thanks,
Vishy
Solved! Go to Solution.
Add those two lines in your Power Query.
Text1 = Table.SelectRows( Text, each [ID] = Text.Select([ID],{"a".."z","A".."Z","0".."9"} ) ),
#"Filtered Rows" = Table.SelectRows(Text1, each [ID] <> "")
You should be able to click on the drop down arrow of a colum and remove values that you do not want (uncheck) and those rows should get filtered out.
You should be able to click on the drop down arrow of a colum and remove values that you do not want (uncheck) and those rows should get filtered out.
Add those two lines in your Power Query.
Text1 = Table.SelectRows( Text, each [ID] = Text.Select([ID],{"a".."z","A".."Z","0".."9"} ) ),
#"Filtered Rows" = Table.SelectRows(Text1, each [ID] <> "")
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |