the latest price on the table

[erhan_79]

hi there ,

i have a table "A "as below ,  i would like to create another new table" B" which shows the latest prices based on latest date .Could you pls help me

[PC2790 · Accepted solution]

Just in case you want to do it in Power Query, you can use the concept of grouping.

Sharing the file with the logic implemented for your reference.

[johnt75]

You could create Table B as

Table B = GENERATE( ALLNOBLANKROW( 'Table A'[Material]),
SELECTCOLUMNS( TOPN(1, 'Table A', 'Table A'[Date]), "Date", 'Table A'[Date], "Price", 'Table A'[Price])
)