Forum Replies Created
-
Posts
-
Got it! Thank you so much for explanation and helping to figure this out.
I’ve just run into another issue. I’m trying to replicate your solution, but I’m getting all blanks when I insert the calculated column “Test Group” in powerpivot. The DAX/column referencing seems to be lining up, but not sure what else I could be doing wrong.
I’ve attached a sample of where I’m hitting a bit of a wall.
This is fantastic. Thank you so much tomallan.
And thank you for all the help with previous posts.
J.
And someone who would have only completed 2 of the tests would fall into one of the 6 categories.
For example, if a case is recorded as having completed V, then NV, they would fall into group 2, as we know that the only next possible test they will take is going to be Q. The same follows for the other 5 possible groupings.
Hopefully this isn’t too convoluted.
I’ve attached a final, comprehensive worksheet that includes my working set and desired result. I’ve put the possible permutations of categories in table form as well as some of the exceptions that might occur.
Essentially I would like to have 6 primary groupings that will occur most frequently in the data (Group 1 – Completed V, then Q, then NV; Group 2 – Completed V, then NV then Q; Group 3 – Completed Q, then V then NV; Group 4 – Completed Q, then NV then V; Group 5 – Completed NV, then V then Q; and Group 6 – Completed NV, then Q then V).
I would also like to identify those that have completed only two of the three, or one of the three and label which those were.
Thank you again
Also, it would not be possible to have taken one of the exams more than once. It would be enforced in the data cleaning step prior to this one.
It would be possible to have taken fewer than 3 exams.
So if a student completed just V and Q, I would want to categorize them in “Group 1”, if they’ve only completed V and NV, “Group 2”, only Q and V “Group 3”, only Q and NV “Group 4”, NV and V “Group 5” and NV and Q “Group 6”.
If they have only completed one test, I would want to return a “missing” label.
Thank you again for all the help. Hope this clarifies a little more.
Hi tomallan,
I’m currently using office 365 (2016).
Attached is an updated version of my working file. I believe I mistakenly uploaded the wrong file. My apologies!
