Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to add latest data on map tooltip?

I'm using ArcGIS maps. I have 3 columns, region_name, temperature and date_time. I want on the map, at the tooltip that appears when you hover your mouse over the bubble, for the latest temperature ...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

     

    Give this a go instead

    Max Temp = 
VAR _last = { CALCULATE(
    MAX( 'Table'[date_time] ),
    ALL( 'Table'[date_time])
) } 
RETURN CALCULATE(
    MAX( 'Table'[temperature] ),
    TREATAS( _last, 'Table'[date_time] )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Mariusz 

 

I get the following error:

 

It's true that I have several date_times that are the same, because I have several regions. Each region has its own date_time. How could I fix this?

 

Thank you.

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

 

Give this a go instead

Max Temp = 
VAR _last = { CALCULATE(
    MAX( 'Table'[date_time] ),
    ALL( 'Table'[date_time])
) } 
RETURN CALCULATE(
    MAX( 'Table'[temperature] ),
    TREATAS( _last, 'Table'[date_time] )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Mariusz  Thank you so much, I appreciate it.

     

    Would you mind explaining why your 2nd solution fixes the issue I had on your 1st one?

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Anonymous ,

       

      Refering to the document abouth LASTDATE. When the current context is a single date, the date returned by the FIRSTDATE and LASTDATE functions will be equal. That's why you got the error message.

       

    • Mariusz's avatar
      Mariusz
      Community Champion
      7 years ago

      Hi Anonymous 

      No problem happy I could help.

       

      For the explanation please refer to v-frfei-msft  post.

       

      Best Regards,
      Mariusz

      Please feel free to connect with me.
      Mariusz Repczynski