How to get value comparing the max and min stock prices

[PbiCeo]

Hello everyone,

There is a table of the NY Dow stock prices for the last 1 month.

I want to get  a date when the min price falls more than 15% from the max price in the last 1 month.

How should it be calculated with DAX?

https://jp.investing.com/indices/us-30-historical-data

Date

Close

Start

High

Low

Volume

Comparison with the previous day%

2020/7/24	26,469.89	26,533.41	26,625.70	26,402.86	497.97M	-0.68%
2020/7/23	26,652.33	26,955.97	26,973.85	26,560.04	426.56M	-1.31%
2020/7/22	27,005.84	26,824.56	27,035.24	26,794.19	410.82M	0.62%
2020/7/21	26,840.40	26,833.14	27,025.38	26,766.22	367.24M	0.60%
2020/7/20	26,680.87	26,660.29	26,765.02	26,504.20	312.07M	0.03%
2020/7/17	26,671.95	26,774.62	26,808.43	26,619.88	300.52M	-0.23%
2020/7/16	26,734.71	26,746.57	26,879.16	26,590.01	288.04M	-0.50%
2020/7/15	26,870.10	27,009.81	27,071.33	26,692.48	388.26M	0.85%
2020/7/14	26,642.59	26,044.17	26,690.52	25,994.98	407.34M	2.13%
2020/7/13	26,085.80	26,225.07	26,639.09	26,044.23	428.57M	0.04%
2020/7/10	26,075.30	25,690.35	26,101.32	25,637.50	337.36M	1.44%
2020/7/9	25,706.09	26,094.92	26,103.28	25,523.51	389.18M	-1.39%
2020/7/8	26,067.28	25,950.06	26,109.49	25,816.25	337.30M	0.68%
2020/7/7	25,890.18	26,172.01	26,174.93	25,866.58	349.00M	-1.51%
2020/7/6	26,287.03	25,996.08	26,297.53	25,996.08	342.26M	1.78%
2020/7/2	25,827.36	25,936.45	26,204.41	25,778.12	350.29M	0.36%
2020/7/1	25,734.97	25,879.38	26,019.31	25,713.61	373.98M	-0.30%
2020/6/30	25,812.88	25,512.43	25,905.38	25,475.14	412.69M	0.85%
2020/6/29	25,595.80	25,152.45	25,601.15	25,096.16	385.13M	2.32%
2020/6/26	25,015.55	25,641.69	25,641.69	24,971.03	676.18M	-2.84%

Thanks for your help,
Vladi

[Greg_Deckler]

@PbiCeo - Well, you could create a calculated column and use EARLIER. See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...