topic Re: I need to find the Difference between rows as anincome criteria date in DAX Commands and Tips

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

Daniels2204 — Mon, 03 Aug 2020 19:23:56 GMT

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:

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

Greg_Deckler — Mon, 03 Aug 2020 19:36:59 GMT

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/339586

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.

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

Greg_Deckler — Mon, 03 Aug 2020 19:40:42 GMT

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?

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

Daniels2204 — Mon, 03 Aug 2020 19:51:25 GMT

Hi, Greg_Deckler

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

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

amitchandak — Tue, 04 Aug 2020 04:22:45 GMT

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

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

Anonymous — Tue, 04 Aug 2020 05:13:18 GMT

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/1143370

Regards,

Harsh Nathani

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

Daniels2204 — Wed, 05 Aug 2020 19:22:14 GMT

Thanks, Anonymous

This is a board with information filter