Forum Discussion
pipkinp86
3 years agoRegular Visitor
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...
- 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))
)
)
pipkinp86
3 years agoRegular Visitor
this is how I ended up fdoing it:
EVALUATE
(
SUMMARIZE(
'Schedule',
'Schedule'[day],
'Schedule'[class],
"StudentList", CONCATENATEX(VALUES('Schedule'[Student]), 'Schedule'[Student],", " & UNICHAR(10))
)
)