cancel
Showing results for
Did you mean:
Member

## Show date for lowest value in a time series

I have a time series of closing values and would like to create a measure that returns the date for the lowest 'close'.

Would appreciate some guidance.

Thanks

Jim B

```Date	        Close
10/01/18	291.73
10/02/18	291.56
10/03/18	291.72
10/04/18	289.44
10/05/18	287.82
10/08/18	287.82
10/09/18	287.4
10/10/18	278.3
10/11/18	272.17
10/12/18	275.95
10/15/18	274.4
10/16/18	280.4
10/17/18	280.45
10/18/18	276.4
10/19/18	276.25
10/22/18	275.01
10/23/18	273.61
10/24/18	265.32
10/25/18	270.08
10/26/18	265.33
10/29/18	263.86
10/30/18	267.77
10/31/18	270.63
11/01/18	273.51
11/02/18	271.89
11/05/18	273.39
11/06/18	275.12
11/07/18	281.01
11/08/18	280.5
11/09/18	277.76
11/12/18	272.57
11/13/18	272.06
11/14/18	270.2
11/15/18	273.02
11/16/18	273.73
11/19/18	269.1
11/20/18	264.12
11/21/18	265.02
11/23/18	263.25
11/26/18	267.5
11/27/18	268.4
11/28/18	274.58
11/29/18	273.98
11/30/18	275.65
12/03/18	279.3
12/04/18	270.25
12/06/18	269.84
12/07/18	263.57
12/10/18	264.07
12/11/18	264.13
12/12/18	265.46
12/13/18	265.37```

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Show date for lowest value in a time series

Hi @JimB-GA

```Measure =
LOOKUPVALUE ( Table1[Date]; Table1[Close]; MIN ( Table1[Close] ) )```

This will generate an error if there is more than one row with minimum [Close]

2 REPLIES 2
Super User

## Re: Show date for lowest value in a time series

Hi @JimB-GA

```Measure =
LOOKUPVALUE ( Table1[Date]; Table1[Close]; MIN ( Table1[Close] ) )```

This will generate an error if there is more than one row with minimum [Close]

Member

## Re: Show date for lowest value in a time series

Perfect.

Thanks for your time in responding.

Jim

Announcements

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)