Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
dorukturkoglu
Helper I
Helper I

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

 

 

1 ACCEPTED SOLUTION
devesh_gupta
Solution Supplier
Solution Supplier

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

 

View solution in original post

3 REPLIES 3
devesh_gupta
Solution Supplier
Solution Supplier

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

 

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? 

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.