Displaying Latest Timestamp per Location in Table Visual with DirectQuery

Hi Diaze2108 

Please try using this measure below, I hope it helps.

LatestData = 
VAR LatestTimestamp = 
    CALCULATE(
        MAX(Snapshots[Timestamp]),
        ALLEXCEPT(Snapshots, Snapshots[Location])
    )
RETURN
    CALCULATE(
        MAX(Snapshots[DataColumn]),  //Replace with your data columns
        FILTER(
            Snapshots,
            Snapshots[Timestamp] = LatestTimestamp
        )
    )

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.