Forum Discussion
meghansh
1 year agoFrequent Visitor
Many to Many relationship
i have 2 tables as Phase and Course. Course has following fields and values CourseID = 1, phase = basic, start date = 24 aug, 2024, end date = 30 aug 2024 CourseID= 1, phase = intermediate, start d...
- Anonymous1 year ago
Hi meghansh
Please try this:
Here's the sample data:
Then add a calculated table:
Table = SELECTCOLUMNS( FILTER( CROSSJOIN( 'Course', SELECTCOLUMNS( 'Phase', "_phase", 'Phase'[phase], "_CourseID", 'Phase'[CourseID], 'Phase'[comment] ) ), 'Course'[CourseID] = [_CourseID] && 'Course'[phase] = [_phase] ), 'Course'[CourseID], 'Course'[phase], 'Course'[start date], 'Course'[end date], 'Phase'[comment] )The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
1 year agoyour sample data does not demonstrate the need for a many to many relationship. Provide sample data with more course IDs, for example.