Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

How 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 ...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    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.

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi Greg_Deckler 

 

Like this?

 

Master Table = 
DISTINCT(
SUMMARIZE( Query1, Query1[[L1.3 - Bev Product]]],Query1[[L1.4 - Brand]]],Query1[[L1.7 - Bev Category]]],Query1[[L1.8 - Bev Segment]]])
)

 

Thanks!

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Other than you shouldn't need the DISTINCT I do not believe but I could be mistaken.