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.

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.

MAAbdullah_47's avatar
MAAbdullah_47
Helper V
5 years ago

Hi 

If the other column other than the summerized need also to be Non-Blank for example in our case (Table1[ID]) how can we do that? 

  • novilpawar's avatar
    novilpawar
    Advocate I
    5 years ago

    Try this-

     

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

     

    Regards,

    Novil

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