cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nick_kz Regular Visitor
Regular Visitor

Power Query M how use IF

Hello !

Language M use IF.jpg

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Power Query M how use IF

@Nick_kz this should work

 

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




Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




1 REPLY 1
Super User
Super User

Re: Power Query M how use IF

@Nick_kz this should work

 

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




Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.