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  Thank you so much, I appreciate it.

 

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

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