Forum Discussion
TAP936
Helper I
5 years agoMultiplying one table by another which is not unique
Hi, I could really do with some help please;
I have two tables
Table 1 contains Home Venue, Away Venue and Ticket Qty
Table 2 contains Home Venue, Away Venue and Mileage ( between home and away)
I have a many to many relationship between table 1 & 2 using home venue
I have created a calculated column in table 1 to show quantity where away venues are the same
=SUMX(FILTER('table 2',[Away venue]=Table1[Away venue]),'Table 1'[Quantity]) this has worked fine
I now need to multiply the quantity in Table 1 by the mileage in Table 2 (not unique)
| Table 1 | Table 2 | ||
| Home Venue | A | Home Venue | A |
| Away Venue | B | Away Venue | B |
| Quantity | 10 | Mileage | 100 |
so in the example above - 10 * 100 = 1000
I'm stuck on how to do this ( it seems like it should be simple), can anyone point me in the right direction?
1 Reply
- AnonymousNot applicable