Extract text by filtering max numeric column

[Anonymous]

Hi folks,

From the below table, how can I extract Company performance by max Year ID from Table B?

So here I need Company performance extracted to Table A by filtering the MAX year ID. Also, if max year ID is not available for Company ID I need to assign it as "Data N/A".

EXPECTED OUTPUT:

[amitchandak]

@Anonymous , Create a new column in table1

new column =
var _max = maxx(filter(table2, table1[company id] = table2[company id]),table2[year id])
return
maxx(filter(table2, table1[company id] = table2[company id] && table2[year id] =_max),table2[company performace])

[Anonymous]

Hey @amitchandak ,

Thanks for the quick help, I also need help to update the query to "Data N/A" when there are no Company Performance values when there is no max YearID for the given company ID.