Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summarize dates without blanks

Hi all,

 

I need help with the following dax. I am creating a table that summerizes the latest dates by id. This works well however I have blank dates. How can I get the latest dates where the id has no blank dates against it?

 

 

MaxID = SUMMARIZE(table1,table1[Id],"LastEntryDate",max(table1[date]))
 
 
Need Help
  • novilpawar's avatar
    novilpawar
    7 years ago

    Anonymous hi

    I have written simple dax similar to your dax except i have applied filter which remove blank dates rows. 

    It have worked for me. 

     

    table2 = SUMMARIZE(FILTER(Table1,Table1[DATE] <> BLANK()),Table1[ID],"MAX DATE",MAX(Table1[DATE]))

     

    Regards,

    Novil

    If I answer you question, please mark my post as solution.

7 Replies

  • vivran22's avatar
    vivran22
    Community Champion
    7 years ago
    Hi,

    Is it possible for you to share some sample table and the desired output?

    Rgds,
    Vivek
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      IdLastEntryDate
      1123/05/2019 0:00
      1223/05/2019 0:00
      1323/05/2019 0:00
      2424/05/2019 0:00
      2524/05/2019 0:00
      26 
      49 
      50 
      5131/05/2019 0:00
      528/06/2019 0:00
      5511/06/2019 0:00
      • novilpawar's avatar
        novilpawar
        Advocate I
        7 years ago

        Anonymous hi

        I have written simple dax similar to your dax except i have applied filter which remove blank dates rows. 

        It have worked for me. 

         

        table2 = SUMMARIZE(FILTER(Table1,Table1[DATE] <> BLANK()),Table1[ID],"MAX DATE",MAX(Table1[DATE]))

         

        Regards,

        Novil

        If I answer you question, please mark my post as solution.