Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
patilpoonam21
Helper I
Helper I

create a table in power bi with the subset of existing table and apply filters

Hi,

 

I want to create a new table which should point to an existing table in Power BI.

Currently I have Table A which has following filters applied:

patilpoonam21_0-1703013339108.png

 

I want to create a new table, Table B which should point to the Table A and unpivot it and apply additional filters.

Currently I am copying all the script from Table A and unpivoting it and applying additional filters. It is loading all the data again from Table A. 

Is there any other way to point directly to the Table A and do all the additional transformations?

 

Thanks,

Rinku

 

 

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@patilpoonam21,

 

Right-click TableA and select Reference. This will create a new table that uses TableA as its source.

 

DataInsights_0-1703169118908.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
DataInsights
Super User
Super User

@patilpoonam21,

 

Right-click TableA and select Reference. This will create a new table that uses TableA as its source.

 

DataInsights_0-1703169118908.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thank you @DataInsights 

 

- Rinku

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors