Forum Discussion
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...
You could also copy the query that creates your 1st table, edit the query and remove the offending column from the query.
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:
Try using SUMMARIZECOLUMNS ...
I think selectcolumns() is what you are looking for:
