Forum Discussion
rhcentennialh
Helper II
Helper IICalculated Column - Two Tables with a Filter or IF stament
What I would like to do is identify the "Names" that are on "Table 2" that are also on "Table 1" that have "Visit Type A". Please let me know if you need further clarifcation ID Name Vis...
- Ah oke what threw us off was the incorrect value at the bottom of Table2 then, as Name C has no Visit A in table 1.
This might be what you are looking for:
CalcColumn =
VAR curName = Table2[Name]
RETURN
IF( COUNTROWS( FILTER( Table1, Table1[Name] = curName && Table1[Visit Type] = "visit A") ) = 0, FALSE, TRUE)
Typing on my phone, so be aware of typos 🙂
If this answers your question, please accept it as the solution:)
az38
Community Champion
Community Championtry column
Calculated Column =
LOOKUPVALUE(
'Table1'[Visit Type],
'Table1'[Name],[Name],
'Table1'[ID],[ID]
)do not hesitate to give a kudo to useful posts and mark solutions as solution