Forum Discussion
Solved
Help with comparing each row to a column in a different table
I am trying to create a calculated column that compares one column to another column in a different table, I want to compare the version of the applications installed in different computers so I can ...
allenind
You can add the following as a new column in Table 1. My Table 1 and 2 are T-1 and T-2, replace accordingly.COMPLIANCY CHECK = IF( ISEMPTY( FILTER( 'T-2', 'T-2'[APPLICATION NAME] = 'T-1'[APPLICATION NAME] && 'T-2'[VERSION] = 'T-1'[VERSION] ) ), "NOTCOMPLANT", "COMPLANT" )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super Userallenind
You can add the following as a new column in Table 1. My Table 1 and 2 are T-1 and T-2, replace accordingly.
COMPLIANCY CHECK =
IF(
ISEMPTY(
FILTER(
'T-2',
'T-2'[APPLICATION NAME] = 'T-1'[APPLICATION NAME] &&
'T-2'[VERSION] = 'T-1'[VERSION]
)
),
"NOTCOMPLANT",
"COMPLANT"
)________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂