Forum Discussion
Creating a Matrix based on the Column Values Separated by Comma
Yes, insert the new column in the same table where you split the rows. The value in Country will copy to the new rows after you split the column, so it should not affect the values.
Hi, thanks for the assistance. I'd like to ask where should I insert the new column? On the same table where I split my rows?
note that i'll also filter it further by country. Would that affect my values?
Yes, insert the new column in the same table where you split the rows. The value in Country will copy to the new rows after you split the column, so it should not affect the values.
Hi DataInsights, how do I show the enrolment in the matrix? Note that I am also using enrolment data age for columns and I'd like to also include the EM Enrolment Calculated in there
Create a measure that sums the custom column created in Power Query. This new column should be used instead of [EM Enrolment Calculated].