How to retrieve specific column value from different table

[AbrahamNaveed]

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.

 

[v-yanimei-msft]

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.

2.Notice that the data type should be same.

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])

4.Add Process, Start_time, End_time to Columns.

5.The outcome is in the following picture.

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]

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.