Hi all!
I have what may be kind of a complex issue.
I’m currently working with a data set in power query and wondering whether there was any way (within either power query, if not perhaps with a DAX formula) to create a flag that will place students in one of three categories based on the order in which they completed a test. I would have to take into consideration the date as well as time (so if a student completed an array of tests on the same date, the time would determine into which category they fell)
I have attached a sample workbook with anonymized data as well as the desired result which will (hopefully) be a clearer reference.
Any suggestions would be greatly appreciated!
Hi Jace,
That's tricky. I created a lookup table for the class order mapping to groups called 'Groups'. Then I unpivoted the original data and merged the first two classes together so I could use them in a lookup to the Groups table.
You can see in the attached file.
Note: There may be a more elegant way to achieve this.
Hope that helps.
Mynda
Mynda Treacy said
Hi Jace,That's tricky. I created a lookup table for the class order mapping to groups called 'Groups'. Then I unpivoted the original data and merged the first two classes together so I could use them in a lookup to the Groups table.
You can see in the attached file.
Note: There may be a more elegant way to achieve this.
Hope that helps.
Mynda
Actually this is doing exactly what I was looking for. Thank you Mynda!
