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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
mterry
Helper V
Helper V

Referencing max date from another table in power query

I'm trying to add a custom column in power query and want to reference the maximum date from another table directly in Power Query. I've seen possible solutions to this, but not exactly like I'm looking for. I can see that I'm able to reference the other table, fxRates1, but not sure what syntax to use in order to get the maximum date from a column named 'Date_BoM' in the fxRates1 table. snip.png

8 REPLIES 8
Ritaf1983
Super User
Super User

Hi @mterry 
You can solve it easily with the ux options of PQ.
1. First step is to merge the tables :

Ritaf1983_0-1708401467864.png

2. Second when expanding just choose the wanted aggregation:

Ritaf1983_1-1708401564535.png

3. fix data type of result to date:

Ritaf1983_2-1708401645364.png

Pbix is attached you can follow my steps

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

I don't want to merge tables, I wanted to reference the other table. 

@mterry 
This is how it works with power query, you need to merge tables.
You can write M code / use ux but the logic is the same.

Refer to other tables without merging possible with DAX calculated columns. 
In your scenario it is by combining 
Maxx + relatedtable.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

No, you don't. Vijay_A_Verma provided the exact solution I was looking for without merging tables. 

Ok, great to know.
Where is the solution? 
For some reason I don't see it

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Good question. I don't know why/how but looks like they split the posts when I marked it as an answer. For anyone else looking seems to be here:

 

https://community.fabric.microsoft.com/t5/Power-Query/Re-Referencing-max-date-from-another-table-in-...

Hi @mterry 
I saw the solution, did you want to bring maximum date without referencing to the category?
Because it is not the same result as a merging ...
It brings the latest date by table level.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Yes - per my original post I wanted the maximum date from another table, I didn't want to merge tables. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.