Forum Discussion
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
- tamerj1Community Champion
Anonymous
How did calculate 3?
- AnonymousNot 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.
- SykResident Rockstar
If the tables are related you could use dax and it would be
column = RELATED('scoresheet'[score])