Missing numbers

Moniek , Create a new table like

Except(generateseries(Min(Table[Number]), Max(Table[Number])), values(Table[Number]))

amitchandak thanks, for sure that is a solution for a lot of another issues. But in this case I want to know of the next number increase with 1 is and I want to generate a list of numbers do not increase with 1. Is that possible?

Hi Moniek ,

Based on this——I want to know of the next number increase with 1 is

You may firstly add a Index column:

Then create a measure to know if increasing with 1:

If Increasing 1 = 
var _preRow= CALCULATE(MAX('Table'[Number]),FILTER(ALL('Table'),[Index]=MAX('Table'[Index])-1))
return IF( MAX('Table'[Number])-1=_preRow,"Yes","No")

Output:

And for this——and I want to generate a list of numbers do not increase with 1

The definition of the third parameter for GENERATESERIES()  is the increment value of the sequence. When not provided, the default value is 1. So you could custom the value:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.