Forum Discussion
column value based on the values from two other columns
1. Identify a primary key in your data. In your case that is a composite key made up of Course Name and Student Grade which I implemented as a calculated column
2. Right click on that primary key column and create (or edit) a group. Now you can bucket collections of primary keys into your Class groups.
3. Use the Class groups column in your visuals.
The same can be achieved with lots of code in either Power Query or DAX, but the column group method is more convenient, and it is sufficient if you don't expect your data to change frequently.
lbendlin I did some reading on that and appreciate you steering me to a totally new area that I have not used in PBI before. I still cannot figure out how to apply that to my desired outcome.
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523