Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to check consecutive numbers

Hello mates!   I have one doubt. I have this Excel: So, I want to know if I don't have consecutive numbers. Something like, if row number is row number - last row number = 1, it's ok. If i...
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Oops, I tried again.

That worked!!! 😄

Thanks mate 🙂