Grouping question

[Anonymous]

I have the following expression in QlikView

if(GRP = '3' or GRP ='4' or (GRP = 'B' & NUM = 233), 'PK' , 'NPK') as group.

I need a smiliar expression to create the column group in power BI.

Thank you.

[jthomson]

Just use the conditional column feature in Power Query to say if it's 3, 4 or b in turn then PK else NPK, then amend the last bit to have your thing also look at the num column like so:

[Anonymous]

Hey

Where is the AND Part in the conditional column?

[jthomson · Accepted solution]

There

[Anonymous]

Thank you!