Page 1 of 1

DAX: Highest Value by Date

Posted: Sat Jul 06, 2019 6:03 am
by Darko_Giac
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 would also like to create a flag for any submissions who happen to bid the same price at the exact same time.

I've attached a sample workbook to hopefully clarify the issue.

https://www.mediafire.com/file/9fnv218am6lhs16/Sample_BiddingWorkbook_2.pbix/file


Any suggestions would be greatly appreciated!

Re: DAX: Highest Value by Date

Posted: Mon Jul 08, 2019 3:44 pm
by PhilC
Hi, have not had a chance to dig into the requirements and a solution but attached is your file with a few measures to get you started.

I have not looked at ties on a single day, or the flag.

Cheers
Phil