Solved: SELECT() with multiple condition not working - Page 2

Bulubulu · 06-26-2023 07:41 AM

I'm trying to filter rows that have the same ref and the same numeric [Seq] value, in order to increment an initial value. Unfortunately, my second condition in line 5 does not work :

MAX(SELECT(
 Shots[Num],
  AND(
   [Storyboard] = [_THISROW].[Storyboard],
   [Seq] = [_THISROW].[Seq]
  )
)) + 10

I guess it's because the [Seq] column is a numeric value and not a reference like the [Storyboard] column is.

Bulubulu

Thanks ! I found my mistake : I forgot to set the initial value of column [Seq] before. So my result was based on an empty value.

I add this initial value to [Seq] column and now it works perfectly !

MAX(SELECT(
 Shots[Seq],
 [Storyboard] = [_THISROW].[Storyboard]
))

View solution in original post