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.
Hello All,
I need help creating a dax measure to the date related to Max head count. I can use the max function to get the max value but not quite sure how to get the date and the day name related to that max head count.
Please find the raw data table and the output below.
Any help is greatly appreciated.
Thanks,
Deevs
Solved! Go to Solution.
@Anonymous , for date name and day, try these two measures
lastnonblankvalue(table[headcount]), max(Table[Date]))
lastnonblankvalue(table[headcount]), max(Table[Day Name]))
And take the game name and head count as not summarized . or max for head count
@Anonymous , for date name and day, try these two measures
lastnonblankvalue(table[headcount]), max(Table[Date]))
lastnonblankvalue(table[headcount]), max(Table[Day Name]))
And take the game name and head count as not summarized . or max for head count
@amitchandak One more question .. how do you handle if there are more than one max head count?
You are a Legend Amit 🙂
what if you have multiple days with the same maximum headcount? How are you planning to break the tie?
....
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 |
---|---|
97 | |
95 | |
76 | |
71 | |
65 |
User | Count |
---|---|
140 | |
109 | |
103 | |
82 | |
73 |