Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiple if in M query

Hi All,     I should create a new Custom Column in powerquery window(M query). if practice = "Technology" and Product = "Agility Loyalty" should print as "Agility Loyalty" if practice = "T...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , new column in M like

    if [Practice] = "Technology" and [Product] = "Agility Loyalty" then "Agility Loyalty" else
    if [Practice] = "Technology" and [Product] = "FRMS" then "FRMS" else
    if [Practice] = "Technology" and [Product] = "Harmony Platform" then "Harmony Platform"
    else [Practice]

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , new column in M like

if [Practice] = "Technology" and [Product] = "Agility Loyalty" then "Agility Loyalty" else
if [Practice] = "Technology" and [Product] = "FRMS" then "FRMS" else
if [Practice] = "Technology" and [Product] = "Harmony Platform" then "Harmony Platform"
else [Practice]