Forum Discussion
Solved
Power query update column from another table.
Hi folks, I have been struggling with this in Power Query. I have 2 tables Table1 UNIT StartDate EndDate 1111 Dec 1, 2020 null 2222 Dec 1, 2020 null 3333 Dec 1, 202...
You do this with a merge. What you are doing is thinking like Excel with a vlookup. That can work ok with a few records, or a few thousand records maybe but above that, it will get super slow.
- Go to Table2
- Remove the EndDate column.
- Select Merge
- Merge with Table1 on the UNIT column
- Expand the StartDate
- Rename StartDate1 to "End Date" - I forgot to do that in this walkthrough.
This will perform very well with larger datasets.
You do this with a merge. What you are doing is thinking like Excel with a vlookup. That can work ok with a few records, or a few thousand records maybe but above that, it will get super slow.
- Go to Table2
- Remove the EndDate column.
- Select Merge
- Merge with Table1 on the UNIT column
- Expand the StartDate
- Rename StartDate1 to "End Date" - I forgot to do that in this walkthrough.
This will perform very well with larger datasets.
