How to get minimum values from another table during ETL

[dorukturkoglu]

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

[devesh_gupta · Accepted solution]

@dorukturkoglu  

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=czNHt7UXIe8

If this helps you, mark it as an accepted solution to help other members find it more easily.

[dorukturkoglu]

Hi, thank you so much for your response

In the last two videos, it is using DAX, are there equivalent formulas to for power query? 

[devesh_gupta]

@dorukturkoglu 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.