Forum Discussion
Solved
How to skip empty values when using summarize+distinct
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.
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
1 Reply
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