Forum Discussion
Mclovin100
3 years agoFrequent Visitor
Looking up a value in a table visual
This seems easy but I cant find a solution for it.
I have two tables.
the first one looks like this
| Year | Month | Measure1 | Measure2 | Measure3 |
| 2022 | Jan | |||
| 2022 | Feb | |||
| 2022 | March |
and the second table looks like this
| Year | Month | StudentsCount |
| 2022 | Jan | 33 |
| 2022 | Feb | 15 |
| 2022 | March | 12 |
I want to find a way to add the studentCount to the first table, I created a one to many relationship between the two. Based on the date but I ended up having multiple rows per the same month and year.
No RepliesBe the first to reply