Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Scoring Moves using Imported Score Table

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

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • Syk's avatar
    Syk
    Resident Rockstar

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