Forum Discussion

RJS849's avatar
RJS849
Frequent Visitor
8 years ago
Solved

To create table using distinct values and using the filter to remove blanks

I need to create a table from two tables by combining distinct values but at the same time using filter to remove any blank values   NEWTable1 = DISTINCT(UNION(VALUES(Table1[Dept_ID]), VALUES(Table...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi RJS849,

     

    Please try:

    NEWTable1 =
FILTER (
    DISTINCT ( UNION ( VALUES ( Table1[Dept_ID] ), VALUES ( Table2[DeptID] ) ) ),
    [Dept_ID] <> BLANK ()
)

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi RJS849,

 

Please try:

NEWTable1 =
FILTER (
    DISTINCT ( UNION ( VALUES ( Table1[Dept_ID] ), VALUES ( Table2[DeptID] ) ) ),
    [Dept_ID] <> BLANK ()
)

Best regards,

Yuliana Gu