topic Re: Get latest data from another table one to many in DAX Commands and Tips

Get latest data from another table one to many

Anonymous — Thu, 15 Sep 2022 07:02:43 GMT

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.

Re: Get latest data from another table one to many

Anonymous — Thu, 15 Sep 2022 07:22:52 GMT

Try to make a New Column using the following measure:

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

Re: Get latest data from another table one to many

Anonymous — Fri, 16 Sep 2022 08:50:29 GMT

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