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

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'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 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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! 😄