Multiple If Condition with Dynamic columns

Hi MMonica , It depends there are multiple ways you could achive that please do try some of these out

• Power Query : Use nested if...then...else or Table.TransformColumns for dynamic column handling.
  if [Column1] = "A" then "Condition A"
  else if [Column2] > 10 then "Condition B"
  else "Default"
  
  

• SQL: Use CASE statements or Dynamic SQL for flexibility.

  SELECT CASE WHEN LOGIC 

• PYTHON:Use apply() or np.select() for dynamic logic.
  If you are going with power query then you could set parameters If your dataset is very large then go with sql as most heavy transformation can be done at source which reduces the execution

   

  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance