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.
o59393Post Prodigy
Post ProdigyHi Greg_Deckler
I want it to be on dax, since it will be a brand new table.
What should be the order?
Master Table =
SUMMARIZE(
(Query1,
DISTINCT(
SELECTCOLUMNS('Query1',"Beverage Product",Query1[[L1.3 - Bev Product]]]),
SELECTCOLUMNS('Query1',"Brand",Query1[[L1.4 - Brand]]],
SELECTCOLUMNS('Query1',"Beverage Category",Query1[[L1.7 - Bev Category]]],
SELECTCOLUMNS('Query1',"Beverage Segment",Query1[[L1.8 - Bev Segment]]],
)
I did that but it's not reading it.
Thanks.
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.
- o59393
Thanks 😄 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.