Forum Discussion
Solved
Two steps in if statement
Hi, in VBA i would have : if 1=1 then 'step 1 'step 2 If is there any equivalent in power query? Best, Jacek
jaryszek
It executes only one step.
If you need to execute two steps either under the true or false part, then it depends on what you exactly are trying to acheve here. You can create a custom function and include all the actions there for this purpose.
Hope this is helpful, if you need to share a scenario with sample data and the expected output, please do so.
jaryszek I have taken a guess here as I am not fully sure what you meant. But can you please give the following a try and see if you meant that by changing the Toggle value
let
Toggle =0,
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WykvMTTVU0lFKSS0AUZkpINLQwEApVgciaQSRNAJLgkgjkGQsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [name = _t, department = _t, id = _t, salary = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"name", type text}, {"department", type text}, {"id", type text}, {"salary", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Commission", each [salary]*0.2),
#"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([name] = "name1")),
Filter = if Toggle=1 then #"Added Custom" else #"Filtered Rows"
in
Filter