2
I have a simple spreadsheet for fuel supply control
3 columns: Date of filling KM Car Plate on odometer at the time of filling.
I want to set up a measurement to know how much was driven in KM
For this you needed to take the Largest KM - the smallest KM for each PLATE(different car) and add it all up.
Problem is, I can’t break down by car within measure, unless I explain it by filtering car by car. However other cars can be registered, and it will not be possible to update the measure.
If I use that measure here:
KM Wheelset = CALCULATE(SUM(ftAbastecimentos[Km]),LASTDATE(ftAbastecimentos[Date of supply])-CALCULATE(SUM(ftAbastecimentos[Km]),FIRSTDATE(ftAbastecimentos[Date of supply]))
I use the date column to catch the KM in the smallest and longest date that appear, subtract and add.
If I place this measure on a table together with the column board, the result appears for each board in the right way. I needed to find a way to add up those values.
If the answer was helpful, remember to mark it as correct.
– John Doe