topic Create new row instances for each number of students identified in the cell in Desktop
https://community.powerbi.com/t5/Desktop/Create-new-row-instances-for-each-number-of-students-identified/m-p/1467494#M612506
<P>Hi,</P><P> </P><P>I have schood data that summarises the column named 'Number of Students' as number values - See below table:</P><P> </P><TABLE border="1"><TBODY><TR><TD>School ID</TD><TD>Year</TD><TD>Semester</TD><TD>Year Level</TD><TD>Assessment Results</TD><TD>Number of students</TD><TD>Assessment Criteria Name</TD></TR><TR><TD>2</TD><TD>2016</TD><TD>1</TD><TD>Year 1</TD><TD>E</TD><TD>7</TD><TD>Reading and viewing</TD></TR><TR><TD>4</TD><TD>2017</TD><TD>2</TD><TD>Year 2</TD><TD>A</TD><TD>105</TD><TD>Reading and viewing</TD></TR><TR><TD>7</TD><TD>2018</TD><TD>3</TD><TD>Year 3</TD><TD>C</TD><TD>170</TD><TD>Reading and viewing</TD></TR><TR><TD>5</TD><TD>2019</TD><TD>4</TD><TD>Year 4</TD><TD>B</TD><TD>58</TD><TD>Reading and viewing</TD></TR></TBODY></TABLE><P> </P><P>I want to create new rows for each number of students identified in the cell 'Number of new students'.</P><P>Example: If 'Number of new students' cell is '58' then create '58' new row instances of that cell.</P><P> </P><P>The goal is to result in a single row for 1 student. Hence... 1 row represents 1 student. </P><P> </P><P>Appreciate the help!</P><P> </P><P>Thanks,</P><P>Theo. </P><P> </P>Sun, 01 Nov 2020 02:58:25 GMTAnonymous2020-11-01T02:58:25ZCreate new row instances for each number of students identified in the cell
https://community.powerbi.com/t5/Desktop/Create-new-row-instances-for-each-number-of-students-identified/m-p/1467494#M612506
<P>Hi,</P><P> </P><P>I have schood data that summarises the column named 'Number of Students' as number values - See below table:</P><P> </P><TABLE border="1"><TBODY><TR><TD>School ID</TD><TD>Year</TD><TD>Semester</TD><TD>Year Level</TD><TD>Assessment Results</TD><TD>Number of students</TD><TD>Assessment Criteria Name</TD></TR><TR><TD>2</TD><TD>2016</TD><TD>1</TD><TD>Year 1</TD><TD>E</TD><TD>7</TD><TD>Reading and viewing</TD></TR><TR><TD>4</TD><TD>2017</TD><TD>2</TD><TD>Year 2</TD><TD>A</TD><TD>105</TD><TD>Reading and viewing</TD></TR><TR><TD>7</TD><TD>2018</TD><TD>3</TD><TD>Year 3</TD><TD>C</TD><TD>170</TD><TD>Reading and viewing</TD></TR><TR><TD>5</TD><TD>2019</TD><TD>4</TD><TD>Year 4</TD><TD>B</TD><TD>58</TD><TD>Reading and viewing</TD></TR></TBODY></TABLE><P> </P><P>I want to create new rows for each number of students identified in the cell 'Number of new students'.</P><P>Example: If 'Number of new students' cell is '58' then create '58' new row instances of that cell.</P><P> </P><P>The goal is to result in a single row for 1 student. Hence... 1 row represents 1 student. </P><P> </P><P>Appreciate the help!</P><P> </P><P>Thanks,</P><P>Theo. </P><P> </P>Sun, 01 Nov 2020 02:58:25 GMThttps://community.powerbi.com/t5/Desktop/Create-new-row-instances-for-each-number-of-students-identified/m-p/1467494#M612506Anonymous2020-11-01T02:58:25ZRe: Create new row instances for each number of students identified in the cell
https://community.powerbi.com/t5/Desktop/Create-new-row-instances-for-each-number-of-students-identified/m-p/1467525#M612514
<P>Managed to resolve it by following the below steps. </P><P> </P><P>Step 1 - Create cutom column</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="S229753_0-1604208621811.png" style="width: 400px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/387488i67B0784830033D58/image-size/medium?v=v2&px=400" role="button" title="S229753_0-1604208621811.png" alt="S229753_0-1604208621811.png" /></span></P><P> </P><P>Step 2 - Split column by Delimiter</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="S229753_1-1604208640860.png" style="width: 400px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/387489i437166C9C7FA466B/image-size/medium?v=v2&px=400" role="button" title="S229753_1-1604208640860.png" alt="S229753_1-1604208640860.png" /></span></P><P> </P><P> </P><P> </P><P> </P>Sun, 01 Nov 2020 05:32:20 GMThttps://community.powerbi.com/t5/Desktop/Create-new-row-instances-for-each-number-of-students-identified/m-p/1467525#M612514Anonymous2020-11-01T05:32:20Z