Hey good folks.
I need help writing an expression that will give me the smallest value not in a list (if that’s even possible
I have a Table called “PINPOINTS”, which has a column called “Geotag Label”
The “Geotag Label” column has all number values (1,2,3, etc…)
What I’d like is for the initial 'Geotag Label" value to be the smallest number not currently in the list.
This way, if i delete value “56” from the Label column, the next row i add will return value “56”
"Between MAX(The Pinpoints[Geotag Label]) & MIN(The Pinpoints[Geotag Label]),
give me MIN(NOT(IN(The Pinpoints[Geotag Label]))),
else gimme MAX(The Pinpoints[Geotag Label] + 1) "
(bad formula, i know. but just an example of what i need)
Can anyone offer any ideas?