topic Need help Merge 3 Tables 3 Column in DAX Commands and Tips

Need help Merge 3 Tables 3 Column

Anonymous — Fri, 02 Sep 2022 12:38:39 GMT

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

Re: Need help Merge 3 Tables 3 Column

Anonymous — Thu, 01 Sep 2022 14:40:58 GMT

Can any help me Please.

Re: Need help Merge 3 Tables 3 Column

v-yadongf-msft — Mon, 05 Sep 2022 06:40:59 GMT

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.