Create a new table from an existing table in Power BI

[hidenseek9]

Hello Power BI community,

A very simple question on creating a new table in Power BI.

Please find below as a sample data

Sample Data

I would like to create a new table in Power BI, almost similar as Sheet 1 in excel file.

I would like the new table to have column A, B, D, E, and F. (just exclude "Timing")

and I would like that table to be always in sync with Sheet 1.

For instance, if I add or delete rows in Sheet 1,

I would like the New Table to reflect the latest data on Column A, B, D, E, and F.

How can I create a table like that?

Thank you for your support.

H

[v-danhe-msft · Accepted solution]

Hi @hidenseek9,

For the first issue, from your description, I would like to know if you want to create a new table in Power BI based on the imported table or just want to import a table without the “Timing” column.

If former, you could add a new table:

Table = SUMMARIZE('Sheet1',Sheet1[Brand Name],Sheet1[Product Name],Sheet1[Date],Sheet1[Number],Sheet1[Contribution %])

If the later one, you could remove the “Timing” column in the edit query.

For the second issue, you just need to click the “Refresh” button, the value in table will be always in sync with Sheet 1.

Regards,

Daniel He

[hidenseek9]

@v-danhe-msft

Thank you for your replay.

Summarize DAX works perfectly.

H