Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

get the date with highest value
11-19-2021
04:59 AM
Hi experts,
I want to get the date where there is the highest value. In the example below the highest value is 15 so the desire result shoud be 11/10/2021.
To get a differente colour Im using the following expression, but I dont know how to get the date itself
Maxvalue =
var alldateincontext= ALLSELECTED('Calendar'[Date])
var themaxvalue = MAXX(alldateincontext, measuretable[numberofpeople])
return
IF(measuretable[numberofpeople] = themaxvalue,"#ff6600")
Thank you!!
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2021
05:04 AM

Hi @Reuben
try this:
MaxDate=
var alldateincontext= ALLSELECTED('Calendar'[Date])
var themaxvalue = MAXX(alldateincontext, measuretable[numberofpeople])
return
Calculate(max('Calendar'[Date]), filter(all(measuretable),measuretable[numberofpeople]=themaxvalue))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2021
05:04 AM

Hi @Reuben
try this:
MaxDate=
var alldateincontext= ALLSELECTED('Calendar'[Date])
var themaxvalue = MAXX(alldateincontext, measuretable[numberofpeople])
return
Calculate(max('Calendar'[Date]), filter(all(measuretable),measuretable[numberofpeople]=themaxvalue))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
07-27-2024 05:45 AM | |||
Anonymous
| 05-15-2024 06:43 PM | ||
02-01-2024 12:59 AM | |||
07-04-2024 04:53 AM | |||
01-11-2024 05:21 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
122 | |
107 | |
85 | |
52 | |
46 |