Filter by paramert values with if conditions

[Nemat2313]

Hi,

How can I add if function to below code? I want if parameter value (yonetici=All ) is equal "ALL" don't filter or filter all esle filtering by parameter value as below. Is it possibe in Power Query?
Filter by paramert values with if conditions

let    
         Source = Table.Combine({#"770 Оборот (2)", #"770 Оборот (1)"}),
         yonetici = fnGetParameter("Yonetici"),
        #"Filtered Rows1" = Table.SelectRows(Source, each ([Yonetici] = yonetici)) 
 
in
        #"Filtered Rows1"

 

[MarcelBeug]

You can do it like this. Thanks to lazy evaluation, the filter step will only be executed if yonetici is not "ALL".

let    
         Source = Table.Combine({#"770 Оборот (2)", #"770 Оборот (1)"}),
         yonetici = fnGetParameter("Yonetici"),
        #"Filtered Rows1" = Table.SelectRows(Source, each ([Yonetici] = yonetici)),
        Result = if yonetici = "ALL" then Source else #"Filtered Rows1"
 
in
        Result