Forum Discussion
Solved
Advanced Filter | Power Query
I am trying to find an efficient way to filter a data set using powerquery. I need to filter out all rows representing a company only when there is no data in another column. But I need to retain al...
NewStep=Table.Combine(Table.Group(YourTable,"Company Name",{"n",each if List.NonNullCount([Descr])=0 the #table(0,{}) else _)})[n])
NewStep=Table.Combine(Table.Group(YourTable,"Company Name",{"n",each if List.NonNullCount([Descr])=0 the #table(0,{}) else _)})[n])