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
mwegener's avatar
mwegener
Most Valuable Professional
5 years ago

Hi Anonymous ,

 

you can append more rows/tables with UNION.

https://dax.guide/union/

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

      • 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?
    • AlexisOlson's avatar
      AlexisOlson
      Super User
      5 years ago

      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.