Forum Discussion
tnicholson
6 years agoFrequent Visitor
Calculation derived from measure
I am new to PowerBI, and so far, I'm not a big fan. I am struggling with a particular project I'm working on for a client. The client is a university that wants to aggregate data by the enrollment st...
- 6 years ago
tnicholson
6 years agoFrequent Visitor
Thank you andre, that gets me closer to what I need. I am now able to see the correct enrollment status per week. Now my next conundrum is how to then pivot on that FT/PT value. The client wants to see the number of students and the credit hours broken out by FT and PT.
This pivot should have 4 columns with count and total credits for FT and the same for PT.
If I try to add the FT/PT calculation to the pivot table columns, it won't let me. I can only add it as a Value.
andre
6 years agoMemorable Member
- tnicholson6 years agoFrequent Visitor
Thank you andre! That did it!
- andre6 years agoMemorable Member
no worries, glad it helped