I have schood data that summarises the column named 'Number of Students' as number values - See below table:
I want to create new rows for each number of students identified in the cell 'Number of new students'.
Example: If 'Number of new students' cell is '58' then create '58' new row instances of that cell.
The goal is to result in a single row for 1 student. Hence... 1 row represents 1 student.
Appreciate the help!
Go to Solution.
Managed to resolve it by following the below steps.
Step 1 - Create cutom column
Step 2 - Split column by Delimiter
View solution in original post
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!