Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JimB-GA
Helper III
Helper III

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
AlB
Super User
Super User

Hi @JimB-GA

 

How about

 

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

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

View solution in original post

2 REPLIES 2
AlB
Super User
Super User

Hi @JimB-GA

 

How about

 

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

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

Perfect.

 

Thanks for your time in responding.

 

Jim

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.