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 t...
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.