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 ChampionMaster 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.
o59393Post Prodigy
Post ProdigyThanks 😄 Greg_Deckler
I used the distinct to avoid duplicates in the beverage product name.
It worked.
Appreaciate your help!
- Greg_DecklerGreat! The reason I didn't think DISTINCT should be necessary is that SUMMARIZE should take care of that by itself specifying the Product name as a group by column.