How I could integrate 2 tables without any relationship?

[Steven_Wu]

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

[Ahmedx · Accepted 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

[Steven_Wu]

Thank you so much~,Ahmedx

That's what I really need 😄