Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi guys,
I have 2 tables. One for invoiced orders and the other for currently orders yet to be shipped. I essentially want to merge these 2 tables as one based on the Order Reference Field as this field indicates that they went to the same Job Location.
But I am unsure how best to do this whther in DAX or power query. I essentially want a new table so I can extract the total sale amounts for both invoiced and yet to be shipped orders. Any help would be appreciated .
@cdawidow In DAX:
UNION('Table1', 'Table2')
In Power Query
Table.Combine(Table1, Table2)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
9 | |
8 |