Forum Discussion
How to determine Time Occurred for Max Wait
LEM8720 , You can create a column Rank or measure rank example
if Needed use use datetime combine field
Datetime = [Date]+[time]
Rank column = rankx(filter(Table, [Queue] = earlier([Queue])),[Wait Time],,desc, dense)
Rank measure = rankx(filter(allselected(Table, Table[Queue],Table [Datetime]) ,Table[Queue] = max([Queue])),calculate(sum([Wait Time])),,desc, dense)
filter for Rank 1
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
Super UserLEM8720 , You can create a column Rank or measure rank example
if Needed use use datetime combine field
Datetime = [Date]+[time]
Rank column = rankx(filter(Table, [Queue] = earlier([Queue])),[Wait Time],,desc, dense)
Rank measure = rankx(filter(allselected(Table, Table[Queue],Table [Datetime]) ,Table[Queue] = max([Queue])),calculate(sum([Wait Time])),,desc, dense)
filter for Rank 1
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
Thanks amitchandak That worked.
