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:)
JarroVGIT
Resident Rockstar
Resident RockstarYOu can add a Calculated column to Table2 that returns a TRUE or FALSE based on your requirements.
Column = IF(Table2[Calculated Column] = "Visit A" && CONTAINS(Table1, Table1[Name], Table2[ Name]), TRUE, FALSE) Results in the following table2:
Let me know if this helps!
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂