I have been attempting to solve this issue for awhile but have hit a snag. I'd like some assistance to create a report to populate the points for fields Drive 1, Driver 2, Driver 3, RGMP, Captain and Turbo in Table 1 for the corresponding Grand Prix in Table 2.
For example, the report would have a chart showing:
Driver 1: Daniil Kvyat 48 points (points from Table 2)
Driver 2: Kimi Raikkonen 42 points
Driver 3: Romain Grosjean -6 points
Captain: Daniil Kvyat 48 points
I understand in Power BI only one field can be joined between two tables. In this case, how to join multiple fields between two tables?