Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help Merge 3 Tables 3 Column

Hi,

 

The requirement is, i have 3 tables with 3 different columns and now i have to use those 3 columns in a new measure
i am unable to merge those 3 columns getting data as null and merging is not happening

 


Table 1 - FinancialKPI
Table 2 - Project custom
Table 3 - Gate

 

Now i need to bring 2 columns from Project custom[Approved Gate], Gate[Value] to FinancialKPI table? Any suggestion please

 


final output i have to achieve by merging 3 tables but not able to merge those columns due to not matching columns

 

- CALCULATE(SUM(FinancialKPI[Y1]),FILTER(FinancialKPI,FinancialKPI[KPIName]=
"Net Sales  [Project Currency]" && FinancialKPI[Approved Gate] = FinancialKPI[value]))

 

 

Thanks

 

 

Desktop
  • v-yadongf-msft's avatar
    v-yadongf-msft
    4 years ago

    Hi Anonymous ,

     

    If you do not matcing columns and want to combine columns, try adding an index column to each table in Power Query as shown below:

     

    Then you can merge by index column:

     

    At last, you can merge 3 tables 3 columns:

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Can any help me Please.

     

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    If you do not matcing columns and want to combine columns, try adding an index column to each table in Power Query as shown below:

     

    Then you can merge by index column:

     

    At last, you can merge 3 tables 3 columns:

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.