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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
AbrahamNaveed
New Member

How to retrieve specific column value from different table

Hello experts - I need help in power bi to combine 2 tables in a way to populate a specific column value from different table.

I've 2 tables: MF table gets data from one source and ETL table gets data from another source.

In MF table, I need to populate start or end time from etl table for jobs listed in a row. Please see below image.

 

 

IMG_6847.jpeg

2 REPLIES 2
v-yanimei-msft
Community Support
Community Support

Hi all , 

@RossEdwards , thanks for your concern about this case, I have some additions for problem solving.

@AbrahamNaveed , thank you for giving a specific description of the problem. Based on your description, I will give you the following steps to solve the problem.

1.The test table MF Table and ETL Table.

vyanimeimsft_0-1711516839022.pngvyanimeimsft_1-1711516843592.png

2.Notice that the data type should be same.

vyanimeimsft_2-1711516857875.pngvyanimeimsft_3-1711516866694.png

vyanimeimsft_4-1711516880037.png

vyanimeimsft_5-1711516887007.png

3.New column Start_time, End_time, and input their DAX code.

 

 

Start_time = 
IF(CONTAINSSTRING('MF Table'[Start time],"Retrieve"),LOOKUPVALUE('ETL Table'[Start time],'ETL Table'[Process],'MF Table'[Process]),'MF Table'[Start time])
End_time = 
IF(CONTAINSSTRING('MF Table'[End time],"Retrieve"),LOOKUPVALUE('ETL Table'[End time],'ETL Table'[Process],'MF Table'[Process]),'MF Table'[End time])

 

 

vyanimeimsft_6-1711516937108.png

4.Add Process, Start_time, End_time to Columns.

5.The outcome is in the following picture.

vyanimeimsft_7-1711516953100.png

 

 

Best Regards,

Caroline Mei

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

 

RossEdwards
Solution Sage
Solution Sage

Using the Power Query Editor, you will have 2 different queries which bring in your MF and ETL tables from their verious sources.

In your ETL table, use the "Merge Tables" button to do a LEFT join with the MF table.  The join will be done using the Process column, since thats your unique value thats common between both tables.

In the next step, you'll see a merged column that appeared from this join.  Click the button in the column name and you'll get the option to split out the columns you need.  Just select the date range columns.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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