Forum Discussion
Difference between two rows
See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
Typically you would need to use EARLIER to achieve what you are going for.
Hi,
why should I use Earlier? I don't have a time comparison to achieve.
Sorry too long, don't have time.
Read what you were doing too quickly. So, I assume that this is a measure. I would try MAX instead of SELECTEDVALUE. SELECTEDVALUE is typically used when dealing with a slicer. MAX of your Fare Index in the context of a row should return the value of the Fare Index in that row. Not sure what SELECTEDVALUE would return for something like that.
Sample source data would allow me to try different things out and be specific with a solution. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
either SELECTEDVALUE or MAX just comes to the same situation where there is data make no sense:
I'm sorry i don't have time to go the whole answer and to give to you an example:
Index AIF Tradeup 1 100 0 2 250 150 3 300 50 4 450 150 i just need the difference between rows :D