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

Anonymous's avatar
Anonymous
Not applicable
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.