Extract data from one table to another

[eamclaughlin]

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! 

[v-juanli-msft · Accepted solution]

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

[Greg_Deckler]

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.