Forum Discussion

BIXL's avatar
BIXL
Resolver 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...
SqlJason's avatar
SqlJason
Memorable Member
10 years ago

In Power BI Desktop, you can create a new calculated table with the formula like shown below

 

NewTableName = SUMMARIZE(ExistingTableName, ExistingTableName[column1], ExistingTableName[column2])

  • KiDix's avatar
    KiDix
    Frequent Visitor
    9 years ago

    IS it possible to add a where clause to this as well??