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

preview_player
Показать описание
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"
Рекомендации по теме
Комментарии
Автор

Amazing! It worked @my power BI database.. you can’t imagine how grateful I am to you, you’ve made my day.. thank you 🙏🏼

leokadia
Автор

Thank you!!! Subscribed!! short but on point!!

juanpaoloyt
Автор

What if I want to remove values that are blank/null?

SloppyNinja
visit shbcf.ru