Forum Discussion
Thangavel_Raju
3 years agoFrequent Visitor
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...
- 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.
ImkeF
3 years agoCommunity Champion
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.