![]() In order to use DAX formulas, we will need to select the Add this to the Data Model option. Select a cell inside the data ➜ go to the Insert tab ➜ then press the Pivot Table button. A student can have multiple rows of data when they are enrolled in multiple courses.Ĭan we summarize this data with a pivot table so that we just display each student once and then show a comma separated list of their courses? Insert A Pivot Tableįirst, we will need to insert a pivot table. Here we’ve got a list of students along with the courses they are enrolled in. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |