Forum Discussion
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.
6 Replies
jaryszek
You can use it this way. PQ is case-sensitive. Please refer to this documentation as well:
https://docs.microsoft.com/en-us/powerquery-m/m-spec-conditionalsif 1 = 1 then step1 else step1Hi,
ok but this is not allowing to run 2 steps? Only either step 1 or step 2?
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.
thank you
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 FilterYes, there is.
How to structure the statement depends on what you want to do.
And there also needs to be an else clause.
