Forum Discussion
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...
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.