Forum Discussion
Solved
Remove Unwanted RANDOM Rows from Data
I have a list of tickets I am pulling from a ticketing system into Power BI using ODATA. The report I am building will be sent to a client each month and will need to be "Groomed" before sending. ...
Anonymous received an error:
Error: Expression.SyntaxError: Token ',' expected.
#"Added Index" = Table.AddIndexColumn(#"Removed Top Rows", "Index", 0, 1, Int64.Type)
#"Remove Row" = Table.SelectRows(#"Added Index", each not List.Contains({4,5}, [Index]))
in
#"Remove Row"
Anonymous received an error:
Error: Expression.SyntaxError: Token ',' expected.
#"Added Index" = Table.AddIndexColumn(#"Removed Top Rows", "Index", 0, 1, Int64.Type)
#"Remove Row" = Table.SelectRows(#"Added Index", each not List.Contains({4,5}, [Index]))
in
#"Remove Row"