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

amitchandak's avatar
amitchandak
Super User
5 years ago

abbas_uddin , Try to add a measure like the first one and try

 

cnt =
VAR __id = MAX ('Table'[USER ID ] )
VAR __date = CALCULATE ( MAX('Table'[Date Time] ), ALLSELECTED ('Table' ), 'Table'[USER ID] = __id )
CALCULATE ( count ('Table'[USER ID] ), VALUES ('Table'[USER ID] ),'Table'[USER ID] = __id,'Table'[Date Time] = __date )

 

if needed have measure for long/lat

Longitude =
VAR __id = MAX ('Table'[USER ID ] )
VAR __date = CALCULATE ( MAX('Table'[Date Time] ), ALLSELECTED ('Table' ), 'Table'[USER ID] = __id )
CALCULATE ( max ('Table'[Longitude] ), VALUES ('Table'[USER ID] ),'Table'[USER ID] = __id,'Table'[Date Time] = __date )

Latitude =
VAR __id = MAX ('Table'[USER ID ] )
VAR __date = CALCULATE ( MAX('Table'[Date Time] ), ALLSELECTED ('Table' ), 'Table'[USER ID] = __id )
CALCULATE ( max ('Table'[Longitude] ), VALUES ('Table'[USER ID] ),'Table'[USER ID] = __id,'Table'[Date Time] = __date )