Lookup not working

[Anonymous]

Hello Community,

Please see below my dataset,I have tried lookup no luck.Can anyone suggest me ?

Table 1
Name	Match Column
GM	GM DISCOUNT
VP	VP DISCOUNT
SALES	Sales DISCOUNT

Table 2
Product	GM DISCOUNT	VP DISCOUNT	Sales DISCOUNT
A	50%	40%	15%
B	60%	30%	10%
C	70%	20%	5%

When user select Product using SLICER VISULIZAITON it should display below result,

PRODUCT SLICER=”A”

Final Result
Name	Discount
GM	50%
VP	40%
SALES	15%

[parry2k]

@Anonymous You need to unpviot your table2. Select Productcolumn in Power Query and right click and chose 'unpivot other columns', it will add two columns "attribute" and "value", rename attribute to "Name" and value to "Discount".

Now if you slicer by product, you will see respective records.

[Anonymous]

Hi Parry,

Than you so much Parry for your suggestions.

My “table 2” has 85 columns and more than million records. I have tried Unpivot Other column and two new columns display very weired dataset.

Do you have any other suggestion?

Thanks

[parry2k · Accepted solution]

@Anonymous interesting, ofcourse without knowing that you so many columns I suggested the solution. One solution might be to make copy of your original table and remove all the other column and keep the column you are interested and then use that for unpivot and make visual from new table.

[Anonymous]

Thank you so much Parry.It is working fine.Thanks