Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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]
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |