Forum Discussion

meghansh's avatar
meghansh
Frequent Visitor
1 year ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    1 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.