Summarizing Data Issue

[dyee4613]

The goal of this report is to analyze milage data.  To do this, I need to calculate how many miles they have driven since the last time data was entered.  To do this, I created three measures. 

Start Date - This is the first date in my data set.  

Start Date =  FIRSTDATE(ALL(Combined[Date])) 

End Date = This is the day before the selected time period.

End Date = MIN(Combined[Date])-1 

Last Odom Reading = This is the highest odometer reading right before the selected date range.  It should always be one day before the last entry.  

Last Odom Reading = CALCULATE(MAX(Combined[Odometer]),DATESBETWEEN(Combined[Date],[Start Date],[End Date]))

The issue I'm running into is my measure doesn't work when there are multiple entries on the same day.

However, when I summarize the entries using sum or max it works perfectly

As a temporary measure, I have used the MAX field so the odometer readings remain consistent however I would like to be able to show all the fields of my data because when there are multiple fuelings on the same day something fishy is usually occurring. 

[dyee4613]

Here are the pictures: it kept giving me an error when I initially made the thread

Summarized DataUnsummarized Data

[v-xuding-msft]

Hi @dyee4613 ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @dyee4613 ,

I created a measure that you can have a try.

Measure = CALCULATE(SUM('Table'[Odometer]), FILTER('Table','Table'[Date] >= MIN('Table'[Date]) && 'Table'[Date] < MAX('Table'[Date])-1))

If it is not what you want, please share your expected results.

Best Regards,

Xue Ding

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