- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to retrieve value from a single column into multiple columns
Hello,
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.
The output has all the CRS_SUBJ_CD,CRS_NBR in 2 columns.
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 CRS_SUBJ_CD,CRS_NBR.
I really appreciate if someone provides any lead.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Data_enthu ,
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.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Data_enthu ,
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.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I am getting the count for CRS_SUBJ_CD and CRS_NBR but getting same count for CROSS_LIST_CRS_SUB_CD and CROSS_LIST_CRS_NBR in PBI

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-30-2024 07:03 AM | |||
05-06-2024 04:34 AM | |||
08-01-2022 03:14 PM | |||
07-18-2024 06:23 AM | |||
06-13-2024 06:49 PM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
9 |