Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
7 years ago
Solved

Create new Table from Last record

Hello,   Is there a way to grab only the LAST record for a bunch of records based on the latest date? In SQL server it is super east and extreemly fast. I woudl simply select * from all rows with M...
Need Help
LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Could you post a a dataset I could copy/paste?

 

gracias

  • LivioLanzo's avatar
    LivioLanzo
    Solution Sage
    7 years ago

    lcasey

     

    try like this:

     

    FILTER(
    NATURALINNERJOIN(
        Table_query__1,
        SUMMARIZECOLUMNS(
            Table_query__1[Company Name - Nombre de Empresa],
            "MaxEventDate", MAX( Table_query__1[Event Date - Fecha de Evento] )
        )
    ),
    [MaxEventDate] = [Event Date - Fecha de Evento]
)
    • lcasey's avatar
      lcasey
      Post Prodigy
      7 years ago

      Unfortunatly that doesnt work.

       

       

       

    • lcasey's avatar
      lcasey
      Post Prodigy
      7 years ago

      Unfortunatly that doesnt work.

       

       

       

       

      • LivioLanzo's avatar
        LivioLanzo
        Solution Sage
        7 years ago

        hello  lcasey

         

        Does your table inside PowerBI have the same name and same column names as the one I am using? I am guessing not. 

        The Query worked on my side, it looks like it is an issue of field names. I have also noticed that you added an extra FILTER expression at the end of my Query