Forum Discussion

Thangavel_Raju's avatar
Thangavel_Raju
Frequent Visitor
3 years ago
Solved

Multiple conditions using cell reference in power query

Dear Friends,   My first message didn't go through I believe.  Hence the second message.   The first table is the master table.  The second is the transaction table.  The master table contains th...
  • ImkeF's avatar
    3 years ago

    Hi Thangavel_Raju ,
    you can achieve this like so:
    1) Check salary in master table and choose "Unpivot other columns"

    2) Merge with transaction table on the new "Attribute"-column and the Rating column from the transaction table.