topic Re: Grouping question in Desktop

Grouping question

Anonymous — Wed, 15 Aug 2018 15:05:22 GMT

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.

Re: Grouping question

jthomson — Wed, 15 Aug 2018 15:19:57 GMT

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:

Re: Grouping question

Anonymous — Wed, 15 Aug 2018 15:27:51 GMT

Hey

Where is the AND Part in the conditional column?

Re: Grouping question

jthomson — Wed, 15 Aug 2018 15:45:16 GMT

There

Re: Grouping question

Anonymous — Wed, 15 Aug 2018 16:24:04 GMT

Thank you!