Forum Discussion
Sum column based off of text data
Hello All:
Quick question that I think will be relatively easy for sum. I'm pulling in some data and transformed that data to only show me courses that have the "First Grade" name in them. That way, I can ensure that I'm getting only the first grade courses and which teachers are teaching those courses. But, I want to sum that so that I can have a Column that will show me Teacher Emily G is teaching 8 first grade courses. Just to make it easier to get a quick look at what the load is for courses on that teacher. This is listing out the courses but I need it summed to a total number. I'm goinng to do the same thing to have a Kindergarten, Second Grade, Third Grade, etc... total columns for each grade. That way we can see that Emily is teaching 2 Kindergarten courses, 8 First Grade Courses, 0 Second Grade courses, etc... and then a total in sum at the end to show 22 total elementary courses being taught by her. Thank you!
17 Replies
- KNP
Super User
Should be easy enough, can you please paste some data to work with? (not a screen shot)
- RyanLMoran
Helper I
I'd be happy to. Would I just attach the PBIX file that I currently have?
- KNP
Super User
If the data is not sensitive, yes. You'll have to share a link to google drive or similar as attaching files is restricted. Alternatively, you could just paste some sample data directly.
Did you see the PBIX I attached earlier? Does this help?
- serpiva64
Solution Sage
Hi,
please provide not an image of data but some sample data in a format one can use.
- RyanLMoran
Helper I
Sure, like the PBIX file or how should I attach that?
- KNP
Super User
There are many ways you can approach this depending on the data and model complexity.
I've attached a simple example PBIX.
Have a look and let me know if you have any questions.