Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
4 years ago
Solved

Missing numbers

Hi,   Question.. In a table is column with numbers, I want to know which numbers are missing. Can anyone help me how to find the missing numbers. Thanks!
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Moniek ,

     

    Sure. Just use the current row minus the previous row:

    Increasing number = 
var _preRow= CALCULATE(MAX('Table'[Number]),FILTER(ALL('Table'),[Index]=MAX('Table'[Index])-1))
return MAX('Table'[Number])- _preRow

    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.

  • Moniek's avatar
    Moniek
    4 years ago

    Yeeaaaaah have a nice day!!!!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Moniek , Create a new table like

 

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

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
4 years ago

Yeeaaaaah have a nice day!!!!