Using IF and AND statements

[jamieham]

I'm new to Power Bi and I'm trying to replicate some old reports I had in SAS and I want to use the IF and AND statements.

How would I replicate the following:

IF ((Tackle Type)="Dominant Tackle" AND (Tackle)="Tackle Assist),1,0)

Any help would be greatly appreciated.

Cheers

J

[mahoneypat]

Try this syntax

Column = if(and(table[tackle type] = "Dominant Tackle", table[Tackle] = "Tackle Assist"), 1, 0)

Regards

Pat

[jamieham]

Thanks for the help