cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DAXRichArd Regular Visitor
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.DAXRichardGuage3.jpg

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

DAXRichArd Regular Visitor
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
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? 

 

DAXRichArd Regular Visitor
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).

 

Your question:

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
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
DAXRichArd Regular Visitor
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