This is my expression:
IF([How many more machines?] = >1, ANY(SELECT(Pre Start[Equipment],MAX(Pre Start[_ROWNUMBER])=[_ROWNUMBER]-1)),"")
If I break it down to:
ANY(SELECT(Pre Start[Equipment],MAX(Pre Start[_ROWNUMBER])=[_ROWNUMBER]-1))
The error being:
Expression ‘EXPRESSION HERE’ could not be parsed due to exception: The given key was not present in the dictionary…
Now I am trying to understand what the error is referring to.
The column mentioned in the beginning of the if statement is a number column, an initial value of 0, and a max count of 2. I believe the issue may be that it is not shown unless another column is marked as True.
Any help is appreciated!