Forum Discussion

MEHUL123's avatar
MEHUL123
Frequent Visitor
2 years ago
Solved

To bring Distinct value in separate table in power query

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.

Need Help
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    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~

     

     

1 Reply

  • xifeng_L's avatar
    xifeng_L
    Super User
    2 years ago

    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~