if Statment, please help

h_gp9
Posts: 23
Joined: Wed Jan 18, 2017 9:50 am

if Statment, please help

Postby h_gp9 » Tue Mar 21, 2017 10:49 am

I need help on how to use if & and in a statement in Power Query but don't how to, please help.

Excel example:

IF(AND(A=0,B=0),1,0)

Same statement need in Power Query.

Thanks for the help.

User avatar
AndVGri
Posts: 31
Joined: Thu Jun 02, 2016 2:41 am
Location: Sankt-Peterburg

Re: if Statment, please help

Postby AndVGri » Wed Mar 22, 2017 7:15 pm

Hi.
It is like VBA

Code: Select all

if A = 0 and B = 0 then 1 else 0

Regards,

h_gp9
Posts: 23
Joined: Wed Jan 18, 2017 9:50 am

Re: if Statment, please help

Postby h_gp9 » Thu Mar 23, 2017 4:14 am

Thank you very much.
Best Regards


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest