Get latest data from another table one to many

[Anonymous]

Hi,

My data looks like below:

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

Index	Value
A	300
B	140
C	50

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

[v-yangliu-msft · Accepted solution]

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:

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]

Try to make a New Column using the following measure:

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