Hi Paul and Sam,
I appreciate finding the other software Paul but i really need to work out the pattern of how to calculate this as I’ll need it not just to calculat Kms but for other calculations as well where I need to search for a similar vehicle above and make time calculations between the two.
For example I want to be able to calculate engine hours as well which is the time difference between an ignition on and off event.
Are we able to have a go at calculating kms in Power BI. I know its difficult but its a key ingredient for me to complete my day to day work. Essentially everything I do involves using kms.
Hope you can help
Regards
Dave