Total Distance Traveled

[Anonymous]

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.

[Greg_Deckler]

@Anonymous - Is this perhaps a Transitive Closure issue? https://community.powerbi.com/t5/Quick-Measures-Gallery/Transitive-Closure/m-p/783828#M388

[Sumanth_23]

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?