Forum Discussion
Group by with where clause Power Query M
Hey, assume i have some table like this: I want to get the row (or just the "interessent" like with group by based on the "interessent" column) with the highest date where "Kategorie" is no...
Hi PhilippRien ,
I think you should filter the category column and only see the records where "Kategorie" is not blank.
Once the data is filtered, you carry out the grouping that you have commented previously. If I'm not mistaken, you would get the result you are looking for.