Google Location History

I hope someone is kind enough to help me with my project....

I extracted my location history from Google Takeout (JSON format). 
My intention was to use various Power BI visuals to "tell a story" of my travels (e.g. Route Map, Flow Map, etc)
My problem is the huge volume of data. 
Google has noted my location 2059 times a day.
I have 3,738,157 rows of data from 1,815 days. (11/17/2013 to 11/6/2018).  

I want to remove the days (rows) where i generally stayed in one location for the day.
However, if it is a date where I traveled long distance, say, from one city to another, i want to keep those rows even though they happen on the same date. 
Can anyone provide a formula or process to remove the rows with duplicate dates?  

And, if anyone has some cool ideas, such as bring in another table for comparing my locations and dates, i would love to hear them.

thank you.