Look up column

[cpereyra]

I have the following table and I need to do a look up to a column based on the month that a date field falls on. 

Table would be as follow... So if I have a sale for employee 1234 in October commission would be 2.00. I already have a relationship from another table POS to filter employee ID. 

Employee ID    10/1/2020      11/1/2020     12/1/2020

  1234                    2.00               2.50               3.00

  2354                    2.50              1.25                2.00

TIA

[v-henryk-mstf]

Hi @cpereyra ,

According to your request, I created a similar matrix. Can you provide samples file or more data for me to test?

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@cpereyra , this table needs to be unpivoted.

https://radacad.com/pivot-and-unpivot-with-power-bi
Then if can be referred by another table on date or month Join ( for column refer: https://www.youtube.com/watch?v=czNHt7UXIe8)

What is the other table, what is expected output.