How to save filtered values to a new column?

[Anonymous]

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

[edhans · Accepted solution]

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.

[Anonymous]

If you want to export it into an entirely new table just right click on the dataset on the queries pane on the left-hand side and click duplicate, apply the filters you want and repeat for each category.