The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |