I created a Table in PowerBI Desktop:
Solved! Go to Solution.
went back to the original table I created. called that one var _Table1 and then set a Union:
Update: read this thread: Union column order - Microsoft Power BI Community
Had to add a nested Summarize to the Second New Table to get it to work..
Seems like a lot more work than it should be...
Your second table needs to match the columns of the table you are unioning it with, not the original shape of the table you are summarizing. Having [UniqueID1] twice in your summary might make this problematic.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.