How to skip empty values when using summarize+distinct

[o59393]

Hi all

How can I skip empty values from a new table I am creating like this?

These values come from a table called query, can the empty values be skipped from my table called "date table" without having to modify the query table?

Thanks.

[amitchandak · Accepted solution]

@o59393 , Try like

summarize(filter(Table,not(isblank(Table[Hire Date]))),Table[Hire Date])

I doubt you need a distinct on top of it. But you can use if needed