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