Forum Discussion

Kumarun's avatar
Kumarun
Helper I
3 years ago
Solved

Latest date

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...
Need Help
  • DimaMD's avatar
    DimaMD
    3 years ago

    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))

     

     

Kumarun's avatar
Kumarun
Helper I
3 years ago


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

I hve live connection