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...
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.
Yes @smoupre, that's what I've done - and indeed it seems the only way; I just thought there might be a more elegant solution. But thanks.