Forum Discussion
Adjust Calculated Column Based on Value from Unrelated Table
Hi All, I have a calculated column which returns some text or blank based on the condition below. Calcuated Column = IF (
Opportunities[Stage of Opportunity]
IN {
...
amitchandak
Super User
Super Userkartiklal7 , if first tbale has a column that can take user id
Calcuated Column = IF ( Opportunities[User ID] in summarize(Filter(Table2, Table2[Role] = "Partner"),Table2[User ID]) &&
Opportunities[Stage of Opportunity]
IN {
"Open - SWA Still Active",
"Open - SWA Expired - Post Grace Period",
"Open - SWA Expired - In Grace Period"
}
|| ( Opportunities[Stage of Opportunity] = "SWA Lost"
&& Opportunities[Reason] = "Available for Winback"),
Opportunities[RequestQuoteURL],
""
)
The first table does not have a column that can take user id and there is no relationship b/w the Opportunities and the User Table. Is there any other way?