Forum Discussion
Adding a Row to a Created Table?
Hello, I created a Table in PowerBI Desktop: Table = Filter( Summarize(ExistingTable, ExistingTable[UniqueID1], ExistingTable[UniqueID1], ExistingTable[Name], ExistingTable[Number1], Existi...
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.