CODEWITHSUNDEEP
powerbidaxpowerbi-desktop
Moun
Moun

Reputation: 315

POWER BI Save Visualised table into a new table (internal data export)

couldn't find an answer for this anywhere. let's say we have 3 tables, when i visualize the join between them i get a table displayed on the screen, i want to save this table as static as it is (for ex in databases we create views)

i want to use this table and to make more process on it (like i could export it inside the file as table and not only as excel or csv)

example

note that some of tables can be a calculation tabs. I don't deal with it on intern without export. I tried to create a new table that makes the join, but the data is somehow unrelated to perform it and sometimes there is 4 or 5 tables in the path to get the join, which PBI do it auto.

Upvotes: 0

Views: 1814

Answers (1)

mxix
mxix

Reputation: 3659

Create a calculated table with the DAX formula you require.

myNewTable = SUMMARIZECOLUMNS(Table[Colonne 1],'Table (2)'[Colonne 1],'Table (3)'[Colonne 1])

Upvotes: 1

Related Questions