Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |