Calculate distance covered by car between two choice dates

[mohsin-raza]

Hi!

I have an example table have cars odometer .

Date	Odometer
17 /10/2021	75475
18 /10/2021	94473
19 /10/2021	117646
20 /10/2021	130786
21 /10/2021	146211
22 /10/2021	158427
23 /10/2021	169678
24 /10/2021	175888
25 /10/2021	187905
26 /10/2021	201116
27 /10/2021	216144
28 /10/2021	229888
29 /10/2021	245463
30 /10/2021	259002

I will make the repport like below so that we choice first and last date and will find the distance covered between given dates .

Can i get a good solution?

[v-rongtiep-msft · Accepted solution]

Hi @mohsin-raza ,

Please have a try.

Create a new table based on the table first.

Table 2 = SUMMARIZE('Table','Table'[Date],'Table'[Odometer])

Then cteate three measures.

start_odometer = CALCULATE(MAX('Table'[Odometer]),FILTER(ALL('Table'),'Table'[Date]=SELECTEDVALUE('Table'[Date])))

end_odometer = CALCULATE(MAX('Table 2'[Odometer]),FILTER(ALL('Table 2'),'Table 2'[Date]=SELECTEDVALUE('Table 2'[Date])))

result = 'Table'[end_odometer]-[start_odometer]

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mohsin-raza]

@v-rongtiep-msft 

one more question please

If we like to sum of odometer from one selected date to another selected date, are we used same logic?

i am trying datebetween().so that i can find the sum between two selected dates.

[mohsin-raza]

@v-rongtiep-msft  Thanks alot for helping. The same logic is implemented for the solution of my problem.

[mohsin-raza]

@v-rongtiep-msft  first thanks for help and i try to implement the same logic on whole dataset then let you know please! 

[mohsin-raza]

Hello again:

Here is the rapport view where date is selected and corresponding car odometer on the date shows in Card Visual  ,when user select second date the corresponding car odometer  is shown in the Card visual  of the  selected  date .

Thinking is to calculate the difference between these two values  and display in the third Card Visual. 

@Admin 

Can i get some solution of  this concept?

Regards.

[mh2587]

what will be the selected duration between start and end date

[mohsin-raza]

Thanks Hasnain for reply.Duration will number of days.

more explanation: when start date is selected , corresponding odometer values need to show  odometer (textbox)/card same when end data is selected ,the corresponding odometer value will show.

Odometer difference need to be display in the card:

[mh2587]

I am asking what will be the range of duration mean for the month or 2 months etc

[mohsin-raza]

Can you please see the table ?

Range is the Date column.

I think you are asking for this