Forum Discussion
Anonymous
7 years agoNot applicable
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
- parry2kSuper User
Anonymous this should work
if [Бренд] = "" and [Сумма] >0 then 1 else 0