Forum Discussion
How to get minimum values from another table during ETL
Hi all, I have a customer table where I have one record for each customer, and I have an order table where I have multiple orders for each customer. To my master table, I would like to add a new column as the minimum order date.
Customer_master:
Customer_ID
X
Y
Order table
Customer_ID Order_Date Quantity
X 5-Jan-2023 23
X 8-Jan-2023 15
Y 7-Feb-2023 36
Y 4-Feb-2023 21
Y 11-Feb-2023 99
In the end I want my customer table to look like this (New column addition)
Customer_ID First_Order_Date
X 5-Jan-2023
Y 4-Feb-2023
Thanks a lot in advance
Anonymous
Power Query Across Table calculated column: https://youtu.be/InjrmY-LJdA
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8If this helps you, mark it as an accepted solution to help other members find it more easily.
3 Replies
Anonymous
Power Query Across Table calculated column: https://youtu.be/InjrmY-LJdA
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8If this helps you, mark it as an accepted solution to help other members find it more easily.
Anonymous I think the first link I shared is for Power Query which is this.
Power Query Across Table calculated column: https://youtu.be/InjrmY-LJdA
Thanks.