Forum Discussion

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

How to summarize columns from different tables

Hi

 

How can I summarize into one table columns from different tables?

 

I have the following [Package], [Product], [Ship From] and [Period] tables:

 

I used summarize to bring up a new table like this, :

 

 

The problem is that I don't know how to combine with other tables.

 

DAX TABLE = 

SUMMARIZE(
    Package, 
    Package[Container Material],
    Package[Container Type],
    Package[Primary Container Volume Capacity],
    Package[L1.4 - Refillability],
    Package[L1.5 - MS-SS],
    Package[BPP Code]
)

 

How can I add the columns below?

 

Ship From[Operation]
Ship From[Region]
Ship From[Country]
Ship From[Bottler Owner]
Ship From[BU Ship From]

 


Period[Month 445]
Period[Year 445]


Product[L1.7 - Segment]
Product[L1.5 - Category]
Product[L1.3 - Trademark Category]
Product[L1.1 - Beverage Product]

 

Measures[Unit Cases AC]
Measures[Unit Cases RE]

 

Thanks!

2 Replies