write a dax code for want to get max date on item and vendor

[Arjunsmart_1994]

Hello Team, 

use the below sample data and write the dax code for want to get max effective date on item id and vendor 

and the sample output is for example the first item is 100021 but effective date is should come 2/7/2023

Please give the soultion as soon as possiable

[Greg_Deckler · Accepted solution]

@Arjunsmart_1994 Try:

Measure =
  VAR __Item = MAX( 'Table'[Item] )
  VAR __Result = MAXX( FILTER( ALLSELECTED( 'Table' ), [Item] = __Item ), [Effective date] )
RETURN
  __Result