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.
Anonymous
1 year agoNot applicable
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.