DAX: Highest Value by Date

Used for anything related to the new Power BI Desktop and Service tools
Darko_Giac
Posts: 5
Joined: Thu Sep 07, 2017 4:19 am

DAX: Highest Value by Date

Postby Darko_Giac » Sat Jul 06, 2019 6:03 am

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!

PhilC
Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

Re: DAX: Highest Value by Date

Postby PhilC » Mon Jul 08, 2019 3:44 pm

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
Attachments
Sample_BiddingWorkbook_2 PPF.pbix
(61.86 KiB) Downloaded 20 times


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 0 guests

cron