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
Anonymous
6 years agoNot applicable
You need to use this matrix
ā
then place school in rows
ft/pt istatus in columns
and then your measures in values.
this should give you the 4 columns your looking for
tnicholson
6 years agoFrequent Visitor
Yes, but unfortunately, FT/PT is a calculation derived from the running total, and as such, cannot be used in columns. That is my conundrum. I need to be able to break out the headcount and credit hours into separate columns for FT and PT.
- Anonymous6 years agoNot applicable
if your its in a calculated column it will work
if you send me a sample i can whip it together