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 = "Technology" and product = "FRMS" should print as "FRMS"

if practicre = "Technology" and Product = "Harmony Platform" should print as "Harmony Platform" 

rest all the all should print as Practice column.

I need all in 1 colum like highlited in Yellow in the above.

 

Thanks in Advance!!

  • 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]

1 Reply

  • 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]