Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 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