Forum Discussion

coollehavre's avatar
coollehavre
Frequent Visitor
7 years ago

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 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 ?

 

Need Help

3 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Worked great for me! Thank you!