dataflow gen2 branching

Hi arkiboys2 ,

 

Thanks for the reply frithjof_v .

 

You need to edit the M code in the Advanced editor.

 

A similar use case is below:

let
  Source = Lakehouse.Contents([]),
  #"Navigation 1" = Source{[workspaceId = "y=YourWorkspaceId"]}[Data],
  #"Navigation 2" = #"Navigation 1"{[lakehouseId = "[YourLakehouseId"]}[Data],
  Navigation = #"Navigation 2"{[Id = "Sales", ItemKind = "Table"]}[Data],
  #"Inserted conditional column 1" = Table.AddColumn(Navigation, "Custom", each if [SalesID] = null then "" else ""),
  #"Added custom" = Table.AddColumn(#"Inserted conditional column 1", "Custom (2)", each if [Amount]>1000 then 1 else 0),
  #"Added custom2" = Table.AddColumn(#"Inserted conditional column 1", "Custom (2)", each if [Amount]>2000 then 1 else 0),
   #"Added custom3" = Table.AddColumn(#"Inserted conditional column 1", "Custom (2)", each if [Amount]>3000 then 1 else 0)
in
  #"Added custom3"

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!