YES/NO peculiar expression for virtual column

Hi guys!

Is there anyone out there who would be able to help me with build expression for next thing.

I’d like to create a virtual column which would be able to find if there was a specific value in a column of Table_2, check if that value is not older than 365 days, AND
where this condition is true: the value of ‘Column_1’ from table where I’d like to add virtual column(Table_1) is equal to the value of column Column_1’ of Table_2

Thanks guys!

Maybe this?

ISNOTBLANK(
  FILTER(
    "Table_2",
    AND(
      ISNOTBLANK([a column]),
      ([a column] = specific-value),
      NOT([a column] < (TODAY() - 365)),
      IF(
        ISBLANK([Column_1]),
        ISBLANK([_THSROW].[Column_1]),
        ([Column_1] = [_THSROW].[Column_1])
      )
    )
  )
)
1 Like

Worked like magic! Thank you very much!!!

1 Like