Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power Query M how use IF

Hello !

 

 

 

 

 

 

 

 

 

 

 

 

Help pls , I have visits with orders, I want to use the function in M: IF(brand = "" and summ >0 , 1, 0). 

I wrote the formula in 2 ways : 

1. How a pict 

2. if [Бренд] = "" and [Сумма] >0 then 1 else 0   

But in M return Error.

 

  • Anonymous this should work

     

    if [Бренд] = "" and [Сумма] >0 then 1 else 0   

1 Reply

  • Anonymous this should work

     

    if [Бренд] = "" and [Сумма] >0 then 1 else 0