Forum Discussion

pipkinp86's avatar
pipkinp86
Regular Visitor
3 years ago
Solved

Report Builder - Matrix with text without aggregation

I need to create the following report, the idea is that students will attend to all classes but in any day, the report needs to group who attend to what in a specific day, I'm using power BI report b...
  • pipkinp86's avatar
    3 years ago

    this is how I ended up fdoing it:

     

    EVALUATE

    (

        SUMMARIZE(

          'Schedule',

            'Schedule'[day],

            'Schedule'[class],

            "StudentList", CONCATENATEX(VALUES('Schedule'[Student]), 'Schedule'[Student],", " & UNICHAR(10))

        )

    )