Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

Calculate Speed

Good dears,

Please could you help me in the following;

to the matrix below I want to add three columns, one that brings the average time, another that calculates the distance and the other that calculates the speed in km / h by ATTRIBUTE.

suguna_2-1630701791401.png

I have the following tables where VALUE is the time in seconds and KM is the distance that the road has in kilometers.

The names of the paths are registered in the ATTRIBUTE variable.

suguna_2-1630701003907.png

The table I look for as a result in the following.

suguna_1-1630701674365.png

I attach the pbix I'm working with.

Thanks a lot!

https://espolec-my.sharepoint.com/:u:/g/personal/suguna_espol_edu_ec/EQwfjeIQe69HnVIgo_MFXVsBphoAWyJ1n0Z0xFIhNMKg9g?e=mwwU2K

2 Replies

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator

      Nice day

      VALUE is the time measured in seconds that a vehicle takes to travel a road (ATTRIBUTE)

      Best regards.