Forum Discussion
power query skip step
Hi, i have a M query that load a value from Excel (Region) let Table_Parametres = Excel.CurrentWorkbook(){[Name="Tableau4"]}[Content], Region= Table_Parametres{1}[Valeur], ... and i would lik...
Not sure if I understand your request, but would this work?:
#"Lignes filtrées"= if Region <> null and Region <> "" then Table.SelectRows(#"Colonnes supprimées", each [TREGION] = Region) else #"Colonnes supprimées"
Worked great for me! Thank you!