Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
obuolys123
Helper I
Helper I

Merging 3 tables into one with particular columns

‎08-11-2022 06:06 AM

Hello, 

I need to merge several columns from 3 tables that are connected with relationships into 1 table.  

 

I have ORDERS table, XTABLE , BILL table and I need NEW table with :


OrderID, Manager, BillID, BillNumber

 

obuolys123_0-1660222960735.png

 

 Has anyone has any ideas on how to do it and is it possible to do it in DAX?


Thank you!

Message 1 of 3
327 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎08-11-2022 06:45 AM

@obuolys123 , Merge in power query

 : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

or Join them and put these column together in visual



View solution in original post

Message 2 of 3
320 Views
2 REPLIES 2
amitchandak
Super User
Super User

‎08-11-2022 06:45 AM

@obuolys123 , Merge in power query

 : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

or Join them and put these column together in visual



Message 2 of 3
321 Views
obuolys123
Helper I
Helper I
In response to amitchandak

‎08-12-2022 12:32 AM

@amitchandak , great, it works!!

Thank you!

Message 3 of 3
314 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All