Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Baburao2123490
Frequent Visitor

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

 

 

1 ACCEPTED SOLUTION
v-yadongf-msft
Community Support
Community Support

Hi @Baburao2123490 ,

 

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:

vyadongfmsft_3-1662360045673.png

 

Then you can merge by index column:

vyadongfmsft_1-1662359683572.png

 

At last, you can merge 3 tables 3 columns:

vyadongfmsft_2-1662359771112.png

 

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.

View solution in original post

2 REPLIES 2
v-yadongf-msft
Community Support
Community Support

Hi @Baburao2123490 ,

 

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:

vyadongfmsft_3-1662360045673.png

 

Then you can merge by index column:

vyadongfmsft_1-1662359683572.png

 

At last, you can merge 3 tables 3 columns:

vyadongfmsft_2-1662359771112.png

 

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.

Baburao2123490
Frequent Visitor

Can any help me Please.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors