I need to find the Difference between rows as anincome criteria date

[Daniels2204]

Hi,

I have a table with hodometers for trucks, i need to find the difference (kilometers) between rows as an income criteria date, additionally the tables are in import mode, but it would be great to work in directquery mode

Aplly this foumula but it does not generate an error not does it generate data, everything is blank

the data is:

[amitchandak]

@Daniels2204 , If you are on direct Query? Replace earlier with max and Try as a measure.

Can you share sample data and sample output in table format? and confirm that you are on direct query. I will try by loading this to DB

[harshnathani · Accepted solution]

Hi @Daniels2204 ,

You cna have a lok at this blog to get your previous values.

https://community.powerbi.com/t5/Community-Blog/Getting-Previous-Values-in-Power-BI-Part-1/ba-p/1143...

Regards,

Harsh Nathani

[Daniels2204]

Thanks, @harshnathani 

This is a board with information filter

[Greg_Deckler]

@Daniels2204 - Wait, I just realized that you are in DirectQuery and you are thus creating a measure and not a calculated column. That's a pretty significant difference. Is that an accurate statement?

[Daniels2204]

Hi, @Greg_Deckler 

Thank you very much for your interest, I´m in duplex mode and I´m not taking measurements, only columns

[Greg_Deckler]

@Daniels2204 - Looks like you are following the pattern similar to here which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

Can't see your DATE_IN column so maybe the issue is there? The overall approach seems valid likely an issue with your FILTER I am guessing.