Forum Discussion
Filter Out a Column Value Identical in Name with Another Value in the Same Column
Hi and appreciate some Power Q help. I want to filter out the bottom three rows to just show the top three rows re Indigenous status, including the ‘Not Stated’ row on the third row. However I’m not ...
NewStep=Table.FromRecords(List.Accumulate(Table.ToRecords(PreviousStepName),{{},[]},(x,y)=>{if Record.HasField(x{1},y[Category]) then x{0} else x{0}&{y},if y[Indigenous Status]<>"Not Stated" or Record.HasField(x{1},y[Category]) then x{1} else x{1}&Record.AddField([],y[Category],"")}){0})
jennratten
Super User
Super UserAre the values in the Category column all the same? Are the values of the Indigeous States really grouped values (rows 1-3 go together and 4-6 go together)? How does 'Not Stated' relate to Non-Indigeous vs. 'Does Not Have Need for Assistance...'?