How to get Date value under a specific price condition

[PbiCeo]

Hello everyone,

I want to get Date if the min price for a certain period of time (for example a month) goes lower than max price for the same time frame with a specific condition.

Date	Price
2020/8/1	25,734
2020/8/2	20,812
2020/8/3	20,095
2020/8/4	20,015

I've created Mesuare like below, but the Date is displayed only as summary on Table Visual.

Measure =
VAR _min = MINX('table', [Price])
VAR _max = MAXX('table', [Price])

Return
minx(FILTER('table', _min < _max * 0.5), [Date])

What is incorrect in the syntax or any advice please?
Thanks in advance,
Vladi

[Sujit_Thakur]

Dear @PbiCeo  ,
Can you please give some example my some dummy data ??
make it in excel of 5-6 rows and paste it here in your post and tell what output is desired in another pasted excel rows

[amitchandak · Accepted solution]

@PbiCeo ,

Measure =
VAR _min = MINX('table', [Price])
VAR _max = MAXX(allselected('table'), [Price])

Return
calculate(minx(values('table'[Date]),[Date]),filter('table',_min <_max))

[Greg_Deckler]

@PbiCeo - Seems like you want Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434