Dax measure to select date for latest/max value

[adavid999]

Hello, 

how do I write a measure to select the date alongside the latest/max value?

Based on below, I would like my measure to display as "07/02/2022" as 1.68 is the latest/max value.

date	index	value
31/01/2022	0	0
07/02/2022	1	1.68
14/02/2022	2	null
21/02/2022	3	null
28/02/2022	4	null
07/03/2022	5	null
14/03/2022	6	null
21/03/2022	7	null
28/03/2022	8	null
04/04/2022	9	null
11/04/2022	10	null
18/04/2022	11	null
25/04/2022	12	null
02/05/2022	13	null

Thanks

A

[freginier · Accepted solution]

Create a measure or column with this

var MaxValue = MAX( 'Table'[Column2] )
return 
LOOKUPVALUE('Table'[Column1],'Table'[Column2],MaxValue)

[adavid999 · Accepted solution]

Thanks @freginier though this doesn't work for me on table below. Do you know why?

var MaxValue = MAX( 'Table'[Column2] )
return 
LOOKUPVALUE('Table'[Column1],'Table'[Column2],MaxValue)

Column1	Column2
31/01/2022	0
07/02/2022	1.68
14/02/2022	null
21/02/2022	null
28/02/2022	null
07/03/2022	null
14/03/2022	null
21/03/2022	null
28/03/2022	null
04/04/2022	null
11/04/2022	null
18/04/2022	null
25/04/2022	null
02/05/2022	null

[freginier]

Can you send me a power bi sample with this 2 columns ? 

[adavid999]

sorry, this did work. I neglected to name the measure when I copied your code

my measure = var MaxValue = MAX( 'Table'[Column2] )
return 
LOOKUPVALUE('Table'[Column1],'Table'[Column2],MaxValue)

[freginier]

Good. Enjoy 🙂

Don't forget to add kudo and accept the solution 😉 

[adavid999]

Hi @freginier I'm not authorised to upload pbix files but it's basically something like this:

[freginier]

See this Pbi file 

https://we.tl/t-CODQTtLNVK 

[freginier · Accepted solution]

Create a measure or column with this

var MaxValue = MAX( 'Table'[Column2] )
return 
LOOKUPVALUE('Table'[Column1],'Table'[Column2],MaxValue)