Forum Discussion

BIXL's avatar
BIXL
Icon for Resolver I rankResolver I
10 years ago

create new table with partial columns from another table in dax

Hi I wonder if there is a way to create a table in dax that is the same like another table but with less colmun. for example : table "A" has "col1","col2","col3" I want to create table "B" with j...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

JohnDawson - Don't copy the table, copy the query. Edit that query to remove the columns that you do not want. You now have 2 queries that create 2 tables, one with all the columns and one with fewer than all of the columns.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler , thanks for this elegant and simple solution.