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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
Anonymous
Not applicable

Get latest data from another table one to many

Hi,

My data looks like below:

Baby33_0-1663224564799.png

This is one table. I have another table with relationship between index  and index (one to many). I want to 

IndexValue
A300
B140
C50

How to get this Value column? It have to be calculated as calculated column due to filtering this data. 

 

 

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Anonymous ,

Here are the steps you can follow:

1. Create calculated column.

Value =
MAXX(FILTER(ALL(Table1),
'Table1'[Index]='Table2'[Index]&&
'Table1'[Date]=MAXX(FILTER(ALL(Table1),'Table1'[Index]=EARLIER('Table1'[Index])),[Date])
),[Value])

2. Result:

vyangliumsft_0-1663318188831.png

 

Best Regards,

Liu Yang

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

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @Anonymous ,

Here are the steps you can follow:

1. Create calculated column.

Value =
MAXX(FILTER(ALL(Table1),
'Table1'[Index]='Table2'[Index]&&
'Table1'[Date]=MAXX(FILTER(ALL(Table1),'Table1'[Index]=EARLIER('Table1'[Index])),[Date])
),[Value])

2. Result:

vyangliumsft_0-1663318188831.png

 

Best Regards,

Liu Yang

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

Anonymous
Not applicable

Try to make a New Column using the following measure:

 

Column = CALCULATE(MAX('Table1'[Value]),FILTER('Table1','Table1'[Index]='Table2'[Column1]))

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.