Forum Discussion
How to save filtered values to a new column?
Hi,
I'm only just getting started using PowerBI, and had trouble finding help with my issue.
Let's say I have a table about fruits. I filtered for the 'fruit' Apple. I'm trying to export the 'type' column to a new table. See example below. How should I do this in the power editor?
| Fruit | Type | Price |
| Apple | Granny Smith | 4 |
| Apple | Fuji | 4 |
| Apple | Honeycrisp | 53 |
| Apple | Fuji | 3 |
Hi Anonymous
You can do this several ways. I generally prefer to create a reference to the source table so as it changes, so do the category tables, etc. You do this by right-clicking on the source table and select Reference. You'll get a new table that points to the old table. Then you can remove all but the one column you want, and remove duplicates. Your query dependency view (in the View tab) would look like this:You can see what I've done in this PBIX file.
2 Replies
- edhans
Community Champion
Hi Anonymous
You can do this several ways. I generally prefer to create a reference to the source table so as it changes, so do the category tables, etc. You do this by right-clicking on the source table and select Reference. You'll get a new table that points to the old table. Then you can remove all but the one column you want, and remove duplicates. Your query dependency view (in the View tab) would look like this:You can see what I've done in this PBIX file.