Forum Discussion

madji's avatar
madji
Helper I
9 years ago
Solved

loading

I am new in PW BI,

Could you help me? 

 

For exemple ( simple) I have 2 tables loading:

 

1.

 

AB
11
22
33

 

2.

AD
25
36
47

 

I try to get tables 3 in script: 

 

AC ( B and D)
11
22
25
33
36
47

 

How can I get it? 

 

Thanks!

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    madji

    You could either try PowerQuery or DAX, see below sample and attached pbix file.

    let
    SelectAndRenameColumnsFromTable1 = Table.RenameColumns(Table.SelectColumns(Table1,{"A","B"}),{"B","C"}),
    SelectAndRenameColumnsFromTable2 = Table.RenameColumns(Table.SelectColumns(Table2,{"A","D"}),{"D","C"}),
    CombineAboutTwo = Table.Combine({SelectAndRenameColumnsFromTable1,SelectAndRenameColumnsFromTable2})
in
    CombineAboutTwo
    combinedTableInDax =
UNION (
    SELECTCOLUMNS ( Table1, "A", Table1[A], "C", Table1[B] ),
    SELECTCOLUMNS ( Table2, "A", Table2[A], "C", Table2[D] )
)

     

3 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    madji

    You could either try PowerQuery or DAX, see below sample and attached pbix file.

    let
    SelectAndRenameColumnsFromTable1 = Table.RenameColumns(Table.SelectColumns(Table1,{"A","B"}),{"B","C"}),
    SelectAndRenameColumnsFromTable2 = Table.RenameColumns(Table.SelectColumns(Table2,{"A","D"}),{"D","C"}),
    CombineAboutTwo = Table.Combine({SelectAndRenameColumnsFromTable1,SelectAndRenameColumnsFromTable2})
in
    CombineAboutTwo
    combinedTableInDax =
UNION (
    SELECTCOLUMNS ( Table1, "A", Table1[A], "C", Table1[B] ),
    SELECTCOLUMNS ( Table2, "A", Table2[A], "C", Table2[D] )
)

     

    • madji's avatar
      madji
      Helper I
      9 years ago

      Eric_Zhang

      Thanks,

      But If I have in first table - 6 columns and in second table - 8


      6 columns are similar.

       

      Are there working for only two columns?

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee
        9 years ago
        madji wrote:

        Eric_Zhang

        Thanks,

        But If I have in first table - 6 columns and in second table - 8


        6 columns are similar.

         

        Are there working for only two columns?

        madji

        You can just add more colulmns in the SELECT columns in my previous post.