Sumproduct formula in power bi

[Anonymous]

I have a lookup table (Daily Target) for four employees (AA, BB, CC, DD). 

Could you please help me to assign the target to Table 2 in the column 'Target'? Thanks a lot.

Daily Target

Table 2

[amitchandak]

@Anonymous ,

The Solution already provided above. You can refer to steps here. In the new office ribbon, it is known as data transformation.

https://radacad.com/pivot-and-unpivot-with-power-bi

[FrankAT · Accepted solution]

Hi,

1. Open Power Query Editor.
2. Select columns AA ... DD.
3. Tab Transform > Unpivot Columns.

Regards FrankAT

[Anonymous]

Thank you. Your answer is very useful

[Greg_Deckler]

I agree with @FrankAT. You might also want to create a column in each table that concatenates values in your employee id and date columns.

[Anonymous]

I also create a new column to combine the Name & Date as key to lookup target.

Thanks for your help.