To bring Distinct value in separate table in power query

[MEHUL123]

Hi,

I have 4 tables in powerbi.

Each table contains "ORDER ID" data colunm (But Order ID data colunm is having different  title in all 4 table)

I need to create separate table in which distinct ORDER IDs to be shown in single colunm. Pls help with M code in powerbi query editor (not DAX)

Pls help,

Thanks in advance.

[xifeng_L · Accepted solution]

Hi @MEHUL123 ,

You can try below Query:

let
    Source = 
        Table.FromColumns(
            {
                List.Distinct(
                    List.Combine(
                        {
                            Table1[OrderIdName1],
                            Table2[OrderIdName2],
                            Table3[OrderIdName3],
                            ...
                        }
                    )
                )
            },
            {"ORDER ID"}
        )
in
    Source

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~