Scoring Moves using Imported Score Table

[Anonymous]

Hello,

       I am working with two tables and I am trying to find a way to create a column in my main table with a score from my score table. I created the score table in excel with all of the possible moves and then assigned a score. I then imported my score table into PowerBI. The main table has different moves from different lots at our yard. The scoresheet has all of the possible moves with a score to them. Below is an example of one move. What I would want in this example is for there to be a score column in my main table with a score of 3 for this move. Not sure on how to calculate this column. As info, there are 521 possible moves and about 70,000 moves total. I have scored all 521 possible moves. Thanks in advance!

Main Table:

Scoresheet

[Syk · Accepted solution]

If the tables are related you could use dax and it would be 
column = RELATED('scoresheet'[score])

[Anonymous]

3 is just a score that I manually assigned to that move. No calculation. I scored all moves 0-6 based on distance of the move in our yard.

[tamerj1]

@Anonymous 

How did calculate 3?