Hi,
I have two data tables that I would like to aggregate. They have different column names and orders.
Could you please let me know how would you aggregate both tables?
For instance:
I want to create an aggregated table that would have Supplier Name and Supplier country data from both tables.
Thank you in advance.
Kind regards,
Salvador
Solved! Go to Solution.
Try like this example
a new table
Distinct(union (
Summarize(Table1,[Supplier name], [Supplier Country]),
Summarize(Table2,[Supplier name], [Supplier Country])
))
Try like this example
a new table
Distinct(union (
Summarize(Table1,[Supplier name], [Supplier Country]),
Summarize(Table2,[Supplier name], [Supplier Country])
))
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
221 | |
46 | |
44 | |
44 | |
42 |
User | Count |
---|---|
276 | |
211 | |
82 | |
75 | |
63 |