Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi, All,
Here is the issue I got as follows:
I have 2 tables in Power BI, first table is like the table A.
| Student | Class | Enrolled Date | Age |
| A | 1-1 | 2022/3/1 | 14 |
| B | 1-2 | 2023/4/1 | 13 |
| C | 1-3 | 2019/2/5 | 13 |
Second table is like table B, it's like a curriculum.
| Course | Planned Period for completion(years) |
| English | 3 |
| Science | 2 |
| Mathematic | 2 |
Is there any way I could combine both of them as the following result without any available relationship?
If it is complicated, please just let me know what direction or rough guide I could follow.
It would be fine. Thank you.
| Student | Class | Enrolled Date | Course | Planned Period for completion(years) |
| A | 1-1 | 2022/3/1 | English | 3 |
| A | 1-1 | 2022/3/1 | Science | 2 |
| A | 1-1 | 2022/3/1 | Mathematic | 2 |
| B | 1-2 | 2023/4/1 | English | 3 |
| B | 1-2 | 2023/4/1 | Science | 2 |
| B | 1-2 | 2023/4/1 | Mathematic | 2 |
| C | 1-3 | 2019/2/5 | English | 3 |
| C | 1-3 | 2019/2/5 | Science | 2 |
| C | 1-3 | 2019/2/5 | Mathematic | 2 |
Solved! Go to Solution.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiBL8KJqFMz5eTNB8?e=dXxdTl
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiBL8KJqFMz5eTNB8?e=dXxdTl
Thank you so much~,Ahmedx
That's what I really need 😄
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.