Need help Merge 3 Tables 3 Column

[Anonymous]

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

[v-yadongf-msft · Accepted solution]

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.

[Anonymous]

Can any help me Please.