Forum Discussion

AbrahamNaveed's avatar
AbrahamNaveed
New Member
2 years ago

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 da...
Combine tables
power bi
v-yanimei-msft's avatar
v-yanimei-msft
Community Support
2 years ago

Hi all , 

Anonymous , 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.