Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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?
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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...

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      5 years ago

      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.