Forum Discussion
Iterate an operation between rows
Hi everyone. I've got a table with the following columns: Item ID Date Warehouse ID Stock quantity Unitary cost of each item Stock value (for each item) Moved quantity (for sales) ...
Anonymous
I am not sure if I understood it correctly, you can add a column as follows:New Column = IF( [Quantita_movimentata] <> Blank() , [Quantita_in_Stock]-[Quantita_movimentata])
Greg_Deckler
Community Champion
Community ChampionAnonymous See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column =
VAR __Current = [Value]
VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])
VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
__Current - __Previous