power query skip step

[coollehavre]

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 like to filter only if there's a value in the Region parameter

i wrote this : 

 #"Lignes filtrées"= if Region<>0 then Table.SelectRows(#"Colonnes supprimées", each [TREGION] = Region) else Table.SelectRows(#"Colonnes supprimées", each [TREGION] = "")

but i would not NOT filter is the Region is empty (actually he filters the TREGION="" )

Could you help me ?

[ImkeF]

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"

[Anonymous]

Worked great for me! Thank you!

[Greg_Deckler]

Calling in @ImkeF