Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I'm looking for a slight modification to a question I had earlier which I can't quite get to work.
I'm looking to create a calculated columns using DAX that will categorize students into one of 6 categories based on when 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 screenshot of sample data as well as the desired result which will (hopefully) be a clearer reference.
Any suggestions would be greatly appreciated
Solved! Go to Solution.
Hi @Darko_Giac
My apologies for late reply
After creating above column, you can create another column as follows to get GROUPINGS.
Please see the Power Pivot Model in attached Excel File
Group = "Group " & RANKX ( Table1, [Notes],, DESC, DENSE )
Try this calculated Column
Notes = VAR FirstClass = MINX ( TOPN ( 1, FILTER ( Table1, [ParticipantID] = EARLIER ( [ParticipantID] ) ), [Assessment_end_date_time], ASC ), [Class] ) VAR SecondClass = MINX ( TOPN ( 1, FILTER ( Table1, [ParticipantID] = EARLIER ( [ParticipantID] ) && [Class] <> FirstClass ), [Assessment_end_date_time], ASC ), [Class] ) RETURN "Completed " & SecondClass & " after " & FirstClass
Thanks for this!
How would I modify the syntax to categorize by groups instead of "Completed X after X".
For example, is there a way to change the label to "Group 1" for those that completed Q after V, "Group 2" for those that completed "NV after V", etc...
Thank you!
D.
Hi @Darko_Giac
My apologies for late reply
After creating above column, you can create another column as follows to get GROUPINGS.
Please see the Power Pivot Model in attached Excel File
Group = "Group " & RANKX ( Table1, [Notes],, DESC, DENSE )
Perfect, thank you!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
38 | |
28 | |
26 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |