Adding a Row to a Created Table?

[kressb]

Hello,

I created a Table in PowerBI Desktop:

Table =

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"))

Now I need to add a Row that's outside the "ExistingTable"

Is there a way to add code to do this?

[mwegener · Accepted solution]

Hi @kressb ,

you can append more rows/tables with UNION.

https://dax.guide/union/

[kressb]

@mwegener 

Yes, but I don't have any table to UNION them from.

IE the data exists only in my head and I want to enter it into the table

[AlexisOlson]

You could use the Enter data button to create a new table with the data in your head or else define it as a DATATABLE with DAX.

[mwegener]

Hi @kressb ,

then you must create the table in the same structure with DATATABLE

https://docs.microsoft.com/en-us/dax/datatable-function

[kressb]

@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?

[kressb]

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]

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.