Forum Discussion
Need Help with Aggregation.
Post is de-identified. I'm new to PowerBI and need some help using aggregation in visualizations. I have three tables, AY (academic year), StudentList, and Volumes. They are set up as below: ...
Thanks ChrisHaas!
I'm looking for the following table with an average Volume per ClassYear:
So I guess ot rephrase, each student is a member of a class. I want to aggregate the volumes for each class member and average that number year and per month.
Each student would be on a difference subspecialty each month. In the end, I want to see something giving me the ability to see the average R1 student's volume in a year, in a month, and in a particular subspecialty.