cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eamclaughlin Frequent Visitor
Frequent Visitor

Extract data from one table to another

Hi All, 

 

I was wondering if there is a way to take info from one table and input it in to another when the 2 tables are not linked?

 

Table 1: Raw Data

Table 2: Created table using "Enter Data"

N.B: These tables are not linked and are unable to be linked

 

I have calculated financial information within Table 1 which has been done using calculated columns that I am able to filter on. I now am looking to populate my newly created table 2 with some financial information from table one;

 

Idea 1: I am able to calculate everything at a top level, although be able to filter Table 2 to only output specific regions or customers. Unsure if this is possible due to their being no links between these tables and the filter data is within table 1

Idea 2: Filter table 1, populate table 2 which will allow for customer export, refilter table 1 which will update in to table 2 for different customer export etc

Idea 3 (Last resort): Input calculations that will output information i need although this means a table per customer or region (minimum of 20 tables) therefore this is not an ideal scenario. 

 

Can anyone suggest or help understand if idea 1 or idea 2 are possible in my approach?

 

Thanks in advance! 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Extract data from one table to another

Hi @eamclaughlin

When you create the new table by entering data, which data do you enter?

Extract data from on etable to another means to add data from Table1 to your new created table, right?

If so, i would suggest you to create  "New table" with DAX function "Summarize".

 

For example:

 

Idea 1: I am able to calculate everything at a top level, although be able to filter Table 2 to only output specific regions or customers. Unsure if this is possible due to their being no links between these tables and the filter data is within table 1

with this formula in "new table"

new table=filter(all(table1),[region]="a")

But the new table would not change with your selection in the slicer. it only extract the specific data as you define in the filter content.

 

if you want the output table to change with the slicer in the Table1,  it is icreating a new table by entering data or clicking on Home->New table  

 

 

Best Regards

Maggie

 

2 REPLIES 2
Super User
Super User

Re: Extract data from one table to another

Source/example data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

LOOKUPVALUE might be an option, depends on your data.


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

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Extract data from one table to another

Hi @eamclaughlin

When you create the new table by entering data, which data do you enter?

Extract data from on etable to another means to add data from Table1 to your new created table, right?

If so, i would suggest you to create  "New table" with DAX function "Summarize".

 

For example:

 

Idea 1: I am able to calculate everything at a top level, although be able to filter Table 2 to only output specific regions or customers. Unsure if this is possible due to their being no links between these tables and the filter data is within table 1

with this formula in "new table"

new table=filter(all(table1),[region]="a")

But the new table would not change with your selection in the slicer. it only extract the specific data as you define in the filter content.

 

if you want the output table to change with the slicer in the Table1,  it is icreating a new table by entering data or clicking on Home->New table  

 

 

Best Regards

Maggie