Remove rows based on column values that contain keywords from a list using Power Query, Power BI

Описание к видео Remove rows based on column values that contain keywords from a list using Power Query, Power BI

Remove rows based on column values that contain keywords from a list using Power Query, Power BI

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each let thisrep = [Year] in List.Count(List.Select({"2015", "2017"}, each Text.Contains(thisrep, _))) = 0)
in
#"Filtered Rows"

Комментарии

Информация по комментариям в разработке