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

     

     

DimaMD's avatar
DimaMD
Solution Sage
3 years ago

Kumarun hi, try it

 

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

 

  • Kumarun's avatar
    Kumarun
    Helper I
    3 years ago

    Hai DimaMD 

    Here I'm getting an error at the remove filter

     

    • DimaMD's avatar
      DimaMD
      Solution Sage
      3 years ago

      Kumarun Show me the error you are getting

  • Kumarun's avatar
    Kumarun
    Helper I
    3 years ago

    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's avatar
      DimaMD
      Solution Sage
      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))