Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Tallis,
You can use group by option in the Power Query editor.
See the below illustration for your reference on how to do this.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
Hi @Tallis,
You can use group by option in the Power Query editor.
See the below illustration for your reference on how to do this.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
Sounds like a "Remove duplicate" problem to me.
If you shorten the coordinates and remove duplicates (in query editor), do you then have a table with fewer points but still your key locations ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |