Latest date

[Kumarun]

Hai Folks,

I have a single employee who has two records but the different dates,
like 
emp id    emp name   date
1             Arun            19-2-22
1            Arun             04-03-22
2           shafi               12-12-22

so, I need only the latest records like 

1            Arun             04-03-22
2           shafi               12-12-22

like this , Here group by function is not working because im using live connection power query is not opened.

Please help me 
thanks in advance

[Kumarun]

Please check now, now I have entered the correct function, if have an import connection removefilter function working. 

I hve live connection

[DimaMD]

@Kumarun hi, try it

Latest = CALCULATE( MAX('table'[date]), REMOVEFILTERS('table'[emp id]))

[Kumarun]

Please find the attachment, 

note: I'm using live sonnection so, removefilter function is not shown in the formula bar we are getting the error

[DimaMD · Accepted solution]

@Kumarun   ok, Explain what you are connecting to, are you using ssas ?
Download the desktop file and try to enter the measure, try this measure

Latest = 
 VAR curdata = SELECTEDVALUE('table'[date])
  return
 CALCULATE( MAX('table'[date]), FILTER('table', 'table'[date] >= curdata))

[DimaMD]

@Kumarun  You missed 1 letter "S"

REMOVEFILTERS

[Kumarun]

Hai @DimaMD 

Here I'm getting an error at the remove filter

[DimaMD]

@Kumarun Show me the error you are getting