Forum Discussion
Power Query Editor - Filter
In M-Code (Power Query), once you apply the filter, that data filtered out is gone. To do what you describe, you need a different method.
If you want to change certain sub-sets of your data, one method is to use Table.Group to create the subsets; then edit each subset. Usually this will need to be done using the Advanced Editor.
You might be able to do some kind of Table.Join with the step prior to your filter, but how to do that, and whether it is better than Grouping, depends on specifics.
In M-Code (Power Query), once you apply the filter, that data filtered out is gone. To do what you describe, you need a different method.
If you want to change certain sub-sets of your data, one method is to use Table.Group to create the subsets; then edit each subset. Usually this will need to be done using the Advanced Editor.
You might be able to do some kind of Table.Join with the step prior to your filter, but how to do that, and whether it is better than Grouping, depends on specifics.
Thank you 🙂