Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Finding Course Instructor name for two particular courses.

Hello Ashish    I have an ORIGINAL TABLE where I have the following columns:   Student Name Student ID Completed Course Course Completion  Course Instuctor Name John 1234 MAT1 1 Dr ...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago
Course Instructor name for MAT1 = COALESCE(CALCULATE(MAX(YourDataTable[Course Instuctor Name]),YourDataTable[Completed Course]="MAT1"),"Course not found")
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello Daniel,

     

    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 "Course not found".