Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm currently attempting to work through a DAX formula that will group my highest value and the date that highest value was submitted.
My data set consists of Date Submitted, Bid, Room and Employee columns. The basic idea is that employees are bidding on certain rooms to rent out for the day, however, if two employees bid the same amount, I would need a way to distinguish a winner (and I am currently attempting to filter on date submitted, which has a time stamp, so that the employee who bid first would win the room).
I've attached a sample workbook to hopefully clarify the issue.
Any suggestions would be greatly appreciated!
Solved! Go to Solution.
Hiya.
Here's your column formula:
Winning Bidder = var __currentRoom = RealTimeData[Room] var __recordsWithCurrentRoom = FILTER( RealTimeData, RealTimeData[Room] = __currentRoom ) var __winnerRecord = TOPN( 1, __recordsWithCurrentRoom, RealTimeData[bid], DESC, RealTimeData[DateSubmit], ASC ) var __winner = MAXX( __winnerRecord, RealTimeData[employee] ) return __winner
Best
Darek
Hi.
Is this to be a measure or calculated column? Excel sucks when it comes to authoring DAX formulas - the formula bar is just a pain to use :((( It's much better to send .pbix files in the future, just so you know.
Best
Darek
Hey hey, @Anonymous this would be a calculated column 🙂
Hiya.
Here's your column formula:
Winning Bidder = var __currentRoom = RealTimeData[Room] var __recordsWithCurrentRoom = FILTER( RealTimeData, RealTimeData[Room] = __currentRoom ) var __winnerRecord = TOPN( 1, __recordsWithCurrentRoom, RealTimeData[bid], DESC, RealTimeData[DateSubmit], ASC ) var __winner = MAXX( __winnerRecord, RealTimeData[employee] ) return __winner
Best
Darek
Thanks so much @Anonymous ! Worked like a charm 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |