Forum Discussion
o59393
Post Prodigy
Post ProdigyHow to create a master table from an existing table
Hi all I need to create a "Master" table that contains the catalog of the unique products and its respective brand, category and segment. The columns are stored in a table called Query1 with ...
Master Table = SUMMARIZE( 'Query1', 'Query1'[L1.3 - Bev Product]], 'Query1'[L1.4 - Brand]], 'Query1'[L1.7 - Bev Category], 'Query1'[L1.8 - Bev Segment] )Unless your column names actually have square brackets in their names, then you would need your double square brackets.
Greg_Deckler
Community Champion
Community ChampionIn DAX, use SUMMARIZE or GROUPBY. In Power Query, use Group By.