Forum Discussion

abbas_uddin's avatar
abbas_uddin
Helper I
5 years ago
Solved

Max Datetime by User with Coordinates

Dear Experts,    I have a table in which User-ID, Recorded Datetime and coordinates are showing. Now i want to show only the max of datetime in the Maps visuals with coordinates. the data below is ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, abbas_uddin 

    Please try the below for creating a new table.

     

    New Table =
    SUMMARIZECOLUMNS (
    'Table'[Consultant ID],
    'Table'[Datetime],
    'Table'[Latitude],
    'Table'[Longitude],
    FILTER (
    'Table',
    'Table'[Datetime]
    = CALCULATE (
    MAX ( 'Table'[Datetime] ),
    ALLEXCEPT ( 'Table', 'Table'[Consultant ID] )
    )
    )
    )
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, abbas_uddin 

Please try the below for creating a new table.

 

New Table =
SUMMARIZECOLUMNS (
'Table'[Consultant ID],
'Table'[Datetime],
'Table'[Latitude],
'Table'[Longitude],
FILTER (
'Table',
'Table'[Datetime]
= CALCULATE (
MAX ( 'Table'[Datetime] ),
ALLEXCEPT ( 'Table', 'Table'[Consultant ID] )
)
)
)
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM