Forum Discussion

Amberr567's avatar
Amberr567
Frequent Visitor
2 years ago
Solved

Adding additional information to a matrix

Hello   I am looking to add additional fields to a matrix, but I am not seeing a solution within power bi.   The user would like to be able to see a summarization field, essentially, that will gi...
  • Amberr567's avatar
    2 years ago

    I ended up working around this with SQL for my data source. 

     

    Case
    when EXISTS(select 1 from CourseCompletion b where b.student= a.student and b.course like '%coursename%') then '1'
    else '0'
    end as 'Course1'