topic Transpose or Unpivot Column? in Desktop
https://community.powerbi.com/t5/Desktop/Transpose-or-Unpivot-Column/m-p/1828226#M709011
<P>Hello Community,<BR />Please review the below,<BR />Can anyone suggest to me how to do it?<BR />I have tried Transpose and Unpivot Column in Power Query but did not get the expected result.<BR />What do I want to do?<BR />Column A,<BR />I am looking for a separate count for 1,2,3,4,5<BR />count "1" in column A=2<BR />count "2" in column A=1</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Raw Data</TD></TR><TR><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR><TD>1</TD><TD>2</TD><TD>3</TD><TD>5</TD><TD>4</TD></TR><TR><TD>5</TD><TD>5</TD><TD>2</TD><TD>5</TD><TD>4</TD></TR><TR><TD>4</TD><TD>4</TD><TD>2</TD><TD>1</TD><TD>1</TD></TR><TR><TD>3</TD><TD>2</TD><TD>4</TD><TD>1</TD><TD>5</TD></TR><TR><TD>1</TD><TD>2</TD><TD>5</TD><TD>3</TD><TD>4</TD></TR><TR><TD>5</TD><TD>4</TD><TD>3</TD><TD>2</TD><TD>1</TD></TR><TR><TD>2</TD><TD>1</TD><TD>4</TD><TD>3</TD><TD>5</TD></TR></TBODY></TABLE><P> </P><P><BR /><BR /></P><TABLE><TBODY><TR><TD>Final Result</TD></TR><TR><TD> </TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD></TR><TR><TD>A</TD><TD>2</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>2</TD></TR><TR><TD>B</TD><TD>1</TD><TD>3</TD><TD>0</TD><TD>2</TD><TD>1</TD></TR><TR><TD>C</TD><TD>0</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>1</TD></TR><TR><TD>D</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>0</TD><TD>0</TD></TR><TR><TD>E</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>3</TD><TD>2</TD></TR></TBODY></TABLE><P><BR /><BR /></P>Thu, 06 May 2021 17:35:49 GMTtejapowerbi1232021-05-06T17:35:49ZTranspose or Unpivot Column?
https://community.powerbi.com/t5/Desktop/Transpose-or-Unpivot-Column/m-p/1828226#M709011
<P>Hello Community,<BR />Please review the below,<BR />Can anyone suggest to me how to do it?<BR />I have tried Transpose and Unpivot Column in Power Query but did not get the expected result.<BR />What do I want to do?<BR />Column A,<BR />I am looking for a separate count for 1,2,3,4,5<BR />count "1" in column A=2<BR />count "2" in column A=1</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Raw Data</TD></TR><TR><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR><TD>1</TD><TD>2</TD><TD>3</TD><TD>5</TD><TD>4</TD></TR><TR><TD>5</TD><TD>5</TD><TD>2</TD><TD>5</TD><TD>4</TD></TR><TR><TD>4</TD><TD>4</TD><TD>2</TD><TD>1</TD><TD>1</TD></TR><TR><TD>3</TD><TD>2</TD><TD>4</TD><TD>1</TD><TD>5</TD></TR><TR><TD>1</TD><TD>2</TD><TD>5</TD><TD>3</TD><TD>4</TD></TR><TR><TD>5</TD><TD>4</TD><TD>3</TD><TD>2</TD><TD>1</TD></TR><TR><TD>2</TD><TD>1</TD><TD>4</TD><TD>3</TD><TD>5</TD></TR></TBODY></TABLE><P> </P><P><BR /><BR /></P><TABLE><TBODY><TR><TD>Final Result</TD></TR><TR><TD> </TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD></TR><TR><TD>A</TD><TD>2</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>2</TD></TR><TR><TD>B</TD><TD>1</TD><TD>3</TD><TD>0</TD><TD>2</TD><TD>1</TD></TR><TR><TD>C</TD><TD>0</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>1</TD></TR><TR><TD>D</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>0</TD><TD>0</TD></TR><TR><TD>E</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>3</TD><TD>2</TD></TR></TBODY></TABLE><P><BR /><BR /></P>Thu, 06 May 2021 17:35:49 GMThttps://community.powerbi.com/t5/Desktop/Transpose-or-Unpivot-Column/m-p/1828226#M709011tejapowerbi1232021-05-06T17:35:49ZRe: Transpose or Unpivot Column?
https://community.powerbi.com/t5/Desktop/Transpose-or-Unpivot-Column/m-p/1828272#M709026
<P>Simply add an index column before unpivoting the dataset,</P>
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2021-05-06 200850.png" style="width: 400px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/509547iFD3A624CCCD58F46/image-size/medium?v=v2&px=400" role="button" title="Screenshot 2021-05-06 200850.png" alt="Screenshot 2021-05-06 200850.png" /></span></P>
<P>Then, counting is easy,</P>
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2021-05-06 201215.png" style="width: 218px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/509549iA5481D52F78003B6/image-size/medium?v=v2&px=400" role="button" title="Screenshot 2021-05-06 201215.png" alt="Screenshot 2021-05-06 201215.png" /></span></P>Thu, 06 May 2021 18:13:09 GMThttps://community.powerbi.com/t5/Desktop/Transpose-or-Unpivot-Column/m-p/1828272#M709026CNENFRNL2021-05-06T18:13:09Z