Multiple If Condition with Dynamic columns

[MMonica]

HI i want to put multiple If conditions in a huge data set with different columns varying. any idea how to do it.

[Akash_Varuna · Accepted solution]

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