How to retrieve value from a single column into multiple columns

Question

Hello,&nbsp;I have a query output where I am getting columns such as enrollment count, CRS_SUBJ_CD (course subject code),CRS_NBR (course subject number), TERM_CD etc.&nbsp;The output has all the&nbsp;CRS_SUBJ_CD,CRS_NBR in 2 columns.&nbsp;Below is the snippet I am trying to recreate in PBI but struggling to get the enrollment numbers for Cross listed course. PS- Crosslisted course are same as&nbsp;CRS_SUBJ_CD,CRS_NBR.&nbsp;I really appreciate if someone provides any lead.&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Data_enthu&nbsp;,
&nbsp;
Do you want to count by CRS_SUBJ and CRS_NBR grouping?
Here's an example.

You can use group by feature in Power Query. Select the both columns and click "Group By...".

In addition to adding a column with a count, add a column that retains the original rows.

Expand it.

&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
&nbsp;
&nbsp;

Forum Discussion

How to retrieve value from a single column into multiple columns

2 Replies

Related content

Retrieve column descriptions from semantic models

Sequential Order column based on multiple criteria

Retrieve Multiple Columns From Another Table

Retrieving data via HTML

Multiple line and clustered columns chart