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




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

     

     

7 Replies

  • 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

  • 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

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