Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to add a blank row in a table?

Hello   I load a table from a source and I want whenever the table is loaded, an empty row to be added with all the respective fields.   What is the best way to do that?   Thanks!
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Create a new table like 

    Table = SELECTCOLUMNS(Sheet1,"id",BLANK(),"value",BLANK())

     

    Then union raw table an new table.

    Table 2 = UNION('Table',Sheet1)

     

    Once refresh the table, blank row will be added.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler  thanks

 

I created and appended the table below:

Column1

[]

 

The Column1 is the same as the name of a column of the table where I want to add the blank row.

The [] means there is no value.

 

However, it did not work. It did not create a blank row. Please note I do not want to create a blank table with all the column fields because the column fields may change so it will not be sustainable.

 

Is there any other way? How can I do it with DAX?

 

The purpose of the empty row is to add the (blank) entry into slicers so that the blank entries that come from non matches of table joins will be filtered.

 

Thanks!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , in Dax you have Row, where you can create a row and then use union and merge it

 

example

Table with Others = UNION(
ROW("ProductCode_wOthers", 0, "Item_wOthers", "0"),
ALLNOBLANKROW('Table','Table'[ProductCode], 'Table'[Item])
)