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