Forum Discussion
Calculate Miles Driven per Vehicle
Hi Power BI experts, Below is a screenshot of a filtered Report. I would like to see how many miles driven between each gas fill-up. But I would like the formula to be by vechicle ID. In my scree...
Daniel,
here's what it looks like when I sort by Date:
All,
I'm new to PowerBI and DAX, so forgive me if the previous posts solved this problem but I still need some help.
I have a table with several different vehicles, [EquipmentID]. I need to be able to filter the table by equipment and come up with a 'Miles per Gallon' for each row. If there is anyone who could throw me a DAX formula for this problem I would greatly appreciate it!
Thanks