Forum Discussion
o59393
Post Prodigy
Post ProdigyHow 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 t...
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
amitchandak
Super User
Super Usero59393 , 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