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!
Solved! Go to Solution.
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])
)
)
)
)
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])
)
)
)
)
Worked like magic! Thank you very much!!!
User | Count |
---|---|
43 | |
29 | |
22 | |
20 | |
15 |