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

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

      • lcasey's avatar
        lcasey
        Post Prodigy
        7 years ago

        They should be the same..... I tried copying again but no luck.

         

        Are you positive Dax is even capable of doing this?  In SQL it is litterally so easy and extreemly simple.  Why Dax needs several lines of code to do such a simple thing is really scarry. Doesnt seem like a very well thought out reporting language.

         

        All I need to do is basically just have a seperate table with all the latest rows based on that event date. Every single column should be included so that I can calculate off of those other columns. I cant remove duplicates as I then cant choose to keep the very latest row in the dataset. 

         

        Very frustrated with these  Power BI limitations!