Forum Discussion
How to check consecutive numbers
Anonymous Correct, so you would substitute your consequetive number column for the date column. So, like the following:
Column = VAR __Current = [ConsequetiveNumberColumn] VAR __Previous = MAXX(FILTER('Table','Table'[ConsequetiveNumberColumn] < EARLIER('Table'[ConsequetiveNumberColumn])),[ConsequetiveNumberColumn]) RETURN __Current - __Previous
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
Hi Greg_Deckler 🙂
Thanks for your answer.
I don't have any Date column... Just the "consecutive" numbers.
How could I adapt the DAX to my problem?
Thanks again!
- Greg_Deckler
Anonymous Correct, so you would substitute your consequetive number column for the date column. So, like the following:
Column = VAR __Current = [ConsequetiveNumberColumn] VAR __Previous = MAXX(FILTER('Table','Table'[ConsequetiveNumberColumn] < EARLIER('Table'[ConsequetiveNumberColumn])),[ConsequetiveNumberColumn]) RETURN __Current - __PreviousOops, I tried again.
That worked!!! 😄
Thanks mate 🙂
Thanks Greg_Deckler 🙂
It seems that didn't work:
Var current and EARLIER don't work 😞
First one, the var says that 'Cannot find name' and it exists 100%.
The other one, 'Parameter is not the correct type'.
Any idea to solve these?
Thanks! 😄