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], 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?
7 Replies
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
Hi Anonymous ,
then you must create the table in the same structure with DATATABLE
https://docs.microsoft.com/en-us/dax/datatable-function