Forum Discussion
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
- AnonymousNot applicable
o59393 ,
You can also consider using SUMMARIZECOLUMNS(), you can directly use the column names between the various tables.
Table3 = SUMMARIZECOLUMNS('Table'[date],'Table'[group],'Table'[NAME],'Table2'[amount])This is a link to related content, hope it will help you:
https://community.powerbi.com/t5/Desktop/Summarize-VS-Summarizecolumn-function-in-DAX/m-p/928113
https://www.powerbigeek.com/understanding-summarizecolumns/
https://www.sqlbi.com/articles/introducing-summarizecolumns/
https://community.powerbi.com/t5/Desktop/Combine-multiple-tables-into-one-table/td-p/60173
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Fowmy
Super User
o59393
You can add columns from multiple tables as long as you have the relationship between the tables. Please refer to this guide:
https://dax.guide/summarize/