Forum Discussion
Total Distance Traveled
so i have a table with an ID column, each ID has many rows to it. for any of the IDs i have an TA History Airport column means which airport it has traveled to, and another column tells the date it has done so, i am trying to figure out a way to calculate total distance traveled for each ID either in a meansure or a separate column, total distance as in from air port to air port. below is the table. I understand this is a really painful problem any help is appreciated.
2 Replies
hi Anonymous - Few questions on the dataset.
#1 - What are the records with nulls for Airport history and Date signify?
#2 - Is there a another column for source airport airport?
#3 - Do you have another table which has the distance between 2 given airport codes
#4 - Is there any way you can share the sample set of the data?
Anonymous - Is this perhaps a Transitive Closure issue? https://community.powerbi.com/t5/Quick-Measures-Gallery/Transitive-Closure/m-p/783828#M388
