Add a line Other to table with 2 columns

[rpinxt]

I have this code that adds a row "Others" to 1 column of a table:

PF+Oth =

FILTER(

UNION (

ALLNOBLANKROW( PF[Prod.Fam.] ),

{ "Others" } ),

NOT ISBLANK( [Prod.Fam.] )

)

However this table has 2 columns. Now I would like that table with 2 columns and Others to both columns.
How would I change this code?

Just adding another line with ALLNOBLANKROW for the 2nd column is not working.

[rpinxt]

@amitchandak 
Not sure how I can make it clearer but this is the table:

Now I have this :

This had a line with Others. But only in column Prod.Fam.

What I would need is also the column Prod.Fam.Lv2 with a line Others in this table.

[Anonymous · Accepted solution]

Hi @rpinxt ,

UNION function only support us to combine tables with same number of columns. According to your screenshot. "PF" table has two columns. {"Others"} only has one column. Now you want to add Other in two columns, so I suggest you to create a table with two columns.

PF+Oth = 
FILTER (
    UNION (
        ALLNOBLANKROW ( PF ),
        ROW ( "Prod.Fam.", "Others", "Prod.Fam.Lv2", "Others" )
    ),
    AND ( NOT ISBLANK ( PF[Prod.Fam.] ), NOT ISBLANK ( PF[Prod.Fam.Lv2] ) )
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rpinxt , Now very clear, but row can help

example of two columns with value

ROW("ProductCode_wOthers", 99, "Item_wOthers", "Others")