DAX Sort by Highest Value and Date RRS feed

  • Question

  • 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.

    Sample Workbook

    Any suggestions would be greatly appreciated!

    Thursday, July 4, 2019 3:46 PM