topic Re: Finding Course Instructor name for two particular courses. in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3109601#M109768 <P>Hello Daniel,</P><P>&nbsp;</P><P>I used your code, selected the Datatable but I am only getting "Course not found" . I have checked the particular course is present in the course list yet its returning&nbsp;<SPAN>"Course not found".&nbsp;</SPAN></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Fri, 03 Mar 2023 07:11:10 GMT Anonymous 2023-03-03T07:11:10Z Finding Course Instructor name for two particular courses. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3109399#M109749 <P>Hello Ashish&nbsp;</P><P>&nbsp;</P><P>I have an ORIGINAL TABLE where I have the following columns:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Student Name</TD><TD>Student ID</TD><TD>Completed Course</TD><TD>Course Completion&nbsp;</TD><TD>Course Instuctor Name</TD></TR><TR><TD>John</TD><TD>1234</TD><TD>MAT1</TD><TD>1</TD><TD>Dr Yun</TD></TR><TR><TD>John</TD><TD>1234</TD><TD>MAT 3</TD><TD>1</TD><TD>Dr Paul</TD></TR><TR><TD>John</TD><TD>1234</TD><TD>ECO 2&nbsp;</TD><TD>1</TD><TD>Dr Man</TD></TR><TR><TD>Liz</TD><TD>7896</TD><TD>MAT1</TD><TD>1</TD><TD>Dr Yun</TD></TR><TR><TD>Liz</TD><TD>7896</TD><TD>MAT 3</TD><TD>1</TD><TD>Dr Paul</TD></TR><TR><TD>Liz</TD><TD>7896</TD><TD>ECO 2&nbsp;</TD><TD>1</TD><TD>Dr Man</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Then I created a "TABLE VISUAL" in Power BI to get the following table where I have used&nbsp;</P><DIV><DIV><SPAN>CONCATENATEX</SPAN><SPAN>(</SPAN><SPAN>VALUES....) function to show all the completed courses in 1 row.&nbsp;</SPAN></DIV><DIV><SPAN>But I cannot get the right most two expected columns.&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Can anyone kindly assist to get the righmost two columns.</SPAN></DIV><DIV>&nbsp;</DIV><DIV>Thanks in advance for your time and consideration.</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV><TABLE><TBODY><TR><TD>Student Name</TD><TD>Student ID</TD><TD>Completed courses</TD><TD>Course Completion</TD><TD><P><STRONG>(Expected Column)</STRONG></P><P>Course Instructor name for MAT1</P></TD><TD><P><STRONG>(Expected Column)</STRONG></P><P>Course Instructor name for MAT 3</P></TD></TR><TR><TD>John</TD><TD>123</TD><TD>MAT 1, ECO2, MAT3</TD><TD>1</TD><TD>Dr Yun</TD><TD>Dr Paul</TD></TR><TR><TD>Adam</TD><TD>1236</TD><TD>MAT 1</TD><TD>1</TD><TD>Dr Yun</TD><TD>Course not found</TD></TR><TR><TD>Sara</TD><TD>1125</TD><TD>ECO 2</TD><TD>1</TD><TD>Course not found</TD><TD>Dr Xuan</TD></TR><TR><TD>Liz</TD><TD>7896</TD><TD>MAT3</TD><TD>1</TD><TD>Course not found</TD><TD>Dr Paul</TD></TR><TR><TD>&nbsp;</TD></TR></TBODY></TABLE> Fri, 03 Mar 2023 04:17:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3109399#M109749 Anonymous 2023-03-03T04:17:25Z Re: Finding Course Instructor name for two particular courses. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3109433#M109751 <DIV> <DIV><SPAN>Course Instructor name for MAT1 = </SPAN><SPAN>COALESCE</SPAN><SPAN>(</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>YourDataTable</SPAN><SPAN>[Course Instuctor Name]</SPAN><SPAN>),</SPAN><SPAN>YourDataTable</SPAN><SPAN>[Completed Course]</SPAN><SPAN>=</SPAN><SPAN>"MAT1</SPAN><SPAN>"</SPAN><SPAN>),</SPAN><SPAN>"Course not found"</SPAN><SPAN>)</SPAN></DIV> </DIV> Fri, 03 Mar 2023 04:54:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3109433#M109751 wdx223_Daniel 2023-03-03T04:54:15Z Re: Finding Course Instructor name for two particular courses. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3109601#M109768 <P>Hello Daniel,</P><P>&nbsp;</P><P>I used your code, selected the Datatable but I am only getting "Course not found" . I have checked the particular course is present in the course list yet its returning&nbsp;<SPAN>"Course not found".&nbsp;</SPAN></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Fri, 03 Mar 2023 07:11:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3109601#M109768 Anonymous 2023-03-03T07:11:10Z Re: Finding Course Instructor name for two particular courses. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3110708#M109857 <P>The solution can be found in my another post</P><P>&nbsp;</P><P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3109958#M109803" target="_blank" rel="noopener">https://community.powerbi.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3109958#M109803</A></P> Fri, 03 Mar 2023 15:24:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Course-Instructor-name-for-two-particular-courses/m-p/3110708#M109857 Anonymous 2023-03-03T15:24:34Z