Forum Discussion
UPDATED Lookup Value in two columns, complex
Hi pros,
I need help. In the sample data, I am trying to identify rows where the Emp No is contained in Attendees and/or is for self when Date and base Exp Type are the same. See highlights - end result should mark yellow lines as True because Jack is listed by Susan AND has meals for self. The submitter's Emp No may or may not appear in the Attendees column (see Jack's Dinner-self).
My goal is to identify expenses where a person submitted a meal AND was an attendee at someone else's meal. Help!
2 Replies
Adding that I've since concatenated the Emp No and Attendee column into a new column, but am stuck with how to identify lines.
Update:
This is the calculated column I'm trying for but I get no results (when I know I should):Emp Lookup = IF(AND(SELECTEDVALUE(Expenses[Date]), ALLSELECTED(Expenses[Exp Type]) && CONTAINSSTRING(Expenses[Column],Expenses[Emp No])),"Yes","")The Dates need to be the same, Exp Type is filtered to Dinner-Self and Dinner-w/others and I want to look up Emp No contained in Column.
