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...
AlexisOlson mwegener
Ok, so selected enter data, created another table with my manual data - used all the same columns in the exact same order and formated them all correctly.
went back to the original table I created. called that one var _Table1 and then set a Union:
Table =
var _Table1 = Filter(
Summarize(ExistingTable, ExistingTable[UniqueID1], ExistingTable[UniqueID1], ExistingTable[Name], ExistingTable[Number1], ExistingTable[Number2], Rollforward[Number3], ExistingTable[Number4], ExistingTable[Number5],ExistingTable[Notes], ExistingTable[Site], "StartDate", Min(ExistingTable[Start Date])),
CONTAINSSTRING(ExistingTable[Notes],"Abc"))
Return
Union (_Table1,SecondNewTable)
Columns between the 2 tables are not matching up.. why?
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.
