Look up column

Question

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.&nbsp;&nbsp;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.&nbsp;&nbsp;Employee ID&nbsp; &nbsp; 10/1/2020&nbsp; &nbsp; &nbsp; 11/1/2020&nbsp; &nbsp; &nbsp;12/1/2020&nbsp; 1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.00&nbsp; 2354&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.00&nbsp;TIA

amitchandak · Accepted Answer

cpereyra , this table needs to be unpivoted.
https://radacad.com/pivot-and-unpivot-with-power-biThen if can be referred by another table on date or month Join ( for column refer: https://www.youtube.com/watch?v=czNHt7UXIe8) 
&nbsp;
What is the other table, what is expected output.

Forum Discussion

Look up column

2 Replies

Related content

New Column

Grouping rows by Column and then updating Column

Unpivot Column

Transform columns / type

Adding columns