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.  ...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    There

     

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?

    • jthomson's avatar
      jthomson
      Solution Sage
      8 years ago

      There

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Thank you!