Distinct and Blank values

[Tanushree_Kapse]

Hi All,

I am having one Main table.

I am creating another table from the main table, having just one product_id column with distinct values.

ProductTab= DISTINCT(Table[product_id])

Current result:

product_id

1

2

3

4

5

6

But in my Main table, I also have blank product ids, for which I've sales.

So I want the blank value too to show in my distinct values column of product_id of new table.

How to get the blank id ?

Expected result:

product_id
1
2
3
4
5
6

Thanks.

[amitchandak · Accepted solution]

@Tanushree_Kapse ,

ProductTab=  union(DISTINCT(Table[product_id]), ROW("product_id", blank())