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...
k3rz0rg's avatar
k3rz0rg
Icon for Advocate III rankAdvocate III
8 years ago

Greg_Deckler I usually follow this steps; try not to bother with dax regarding minor stuffs; like duplicate table, drop the unnecessary column, if required, remove duplicates, then if required, add the relationship manually. Yet just wanted to refresh my memory with dax expressions... :smileyvery-happy:

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Try using SUMMARIZECOLUMNS ...