Power Query Create Column Syntax

[detriez]

I am trying to add a column with this criteria

if
(
[AnnualRevenue] >= 250000000
and
[Has Products]="True"
and
[Is Target]="True"
and
[Marketing Country]="True"
)
or
[AccountTypeGroup]="Client"
or
[Is Target]="True"
then "True" else "False"


I'm not sure I have the syntax correct

if([AnnualRevenue] >= 250000000 and [Has Products]="True" and [Is Target]="True" and [Marketing Country]="True") or [AccountTypeGroup]="Client" or [Is Target]="True" then "True" else "False"

 

[sandy666]

maybe

= if [AnnualRevenue] >= 250000000 and [Has Products] = true and [Is Target] = true and [Marketing Country] = true or [AccountTypeGroup] = "Client" or [Is Target] = true then true else false

true/false or true/false or true/false then true/false
I don't know if it will work because syntax is syntax but result is ?

 

[sandy666]

a lot of strange things are done in Power Query

 

[detriez]

Argh..
My logic was wrong... (I was using [Is Target] in the and as well as the or portion)

I'm trying to get to..

If [Is Target] is true then True
or else if
If [AccountTypeGroup] =Client then True
or else if
[AnnualRevenue] >= 250000000 and [Has Products] = "True" and [Marketing Country] = "True" then True

else False

THis doesnt get me there either

if [AccountTypeGroup] = "Client" then true else if [Is Target] = "True" then true else if [AnnualRevenue] >= 250000000 and [Has Products] = "True" and [Marketing Country] = "True" then true else false

 

[sandy666]

maybe representative piece of data and M for that?
use XL2BB to post example