Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Grouping question

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.

Need Help

4 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      Hey

       

      Where is the AND Part in the conditional column?