cancel
Showing results for
Did you mean:
Regular Visitor

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

Sorry for the inconvinience and again thank you for your follow through. I can't say thank you enough. The dashboard I want to create will look something like the attached image.

Super User

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

@DAXRichArd

OK so let's say we have in the slicer the following:

Month: February

Year: 2015

Airport: HOU

Region: USA

What would be the result for each of the three measures you want? Explain conceptually how it would be calculated so that I can understand if I missed something earlier?

Regular Visitor

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

Hi AIB,

Month: February

Year: 2015

Airport: HOU

Region: USA

My gauges would show:

• The lowest reading for the entire data set for the month of February (this is the lower boundary (minimum value)  of the guage)
• For HOU Airport
• For the region USA
• The highest reading for the entire data set for the month of February (this is the upper boundary (maximum value) of the guage)
• For HOU Airport
• For the region USA
• The current reading for February 2015
• For HOU Airport
• For the region USA

Thx

DAXRichard

Super User

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

@DAXRichArd

Ok, so for the min and max we would be looking at the month February of all years in your data. Correct?

Regular Visitor

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

Good morning,

Sorry if this is a repeat reply (had internet connectivity problems from home this moring).

Ok, so for the min and max we would be looking at the month February of all years in your data. Correct?

Response:

Yes, that is correct.

DAXRichard

Super User

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

@DAXRichArd

OK, then we need to update the [Passengers] measure we had before to ignore the year:

```Passengers =
CALCULATE ( SUM ( 'FT Passengers'[Pax] ); ALL ( CalendarTable[Year] ) )```

With that I think you should be able to build your gauges. If you need more variations on what to consider from the slicers and what not, you'd need to update the measures again.

Highlighted
Regular Visitor

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

Ahhh.... I'm my own  worst enemy. I was explecting something complicated. I guess I was over engineering it. Big thanks AIB. I'll give it a try hopefully sometime today.

DAXRichard