Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello -
I have merged 2 tables in the power query editor to create a MergedTable.
I want to delete all rows in the MergedTable in which category <> "Split".
I can't figure out how to do that.
When I go to the Power Editor, the only option I see from the ribbon is to Remove Rows - choices are top x or bottom x or alternating, etc. I can also choose to Keep Rows with similar options.
What's the syntax to remove the rows using the criteria category <> "Split"? Can’t I add that logic directly to the query?
Thanks for any help.
Solved! Go to Solution.
Can you select a filter from the column header (category?)
Ah, I think I understand. You managed to filter the data but you were looking for an additional process to 'complete' but the filter was the final step in the process.
It's not like the powerbi desktop data view where you can filter the data for inspection but the table is still populated with all rows.
Exactly! I was thinking of data manipulation in Excel - if you want to remove the rows, you physically have to delete them. Don't worry, I catch on fast. 😃 Thanks again.
Let me be clearer. Each column header has a dropdown caret, click on that. You will see options which are customised depending on the data type.
I think I figured this out. Filtering in the power query removes the rows - you don't physically have to delete the records once you've set the filter. Duh. Thanks.
Can you select a filter from the column header (category?)
Yes, I can filter the rows I want to delete, but I'm not sure how to actually delete them once I've done that. As I said, when I select "Remove Rows" there's no option to delete everything that's filtered.
I'm a newbie to the power query editor. My dba performed most of the data manipulation in SQL before I received the data, but he was let go due to downsizing so I'm trying to figure things out.
Thank you!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |