Forum Discussion
Calculating difference between consecutive rows
Hi all,
i manged to solve this using this answer:
basicly i had to calculate for each date the previous date (under the current filters) and then return the result for that date
Up until that last requirement, you could have just used a calculated column with EARLIER.
Now, you will need a measure and use a VAR to grab your current table (as filtered by user). Then, use ADDCOLUMNS to add a column using EARLIER to that table and do your calculations.
Here is an article on the use of EARLIER:
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
sorry i think i mix things up.. actualy what i reffered to as my data is actualy a visual matrix / table based on the data.
does this change somthing ?
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