Forum Discussion
Solved
Add Column Apply to Each Row with Multiple Criteria
Good afternoon, **Edit** I'm looking for something similar to this Fiber = IF ('Table'[Customer ID] IN {IF (FIND ("Fiber", 'Table'[Plan Name],1,BLANK()), 'Table'[Customer ID], BLANK())}, "Y"...
Hi,
Thanks for the solution ToddChitt offered, and i want to offer some more information for user to refer to.
hello Spudonis , you can create a calculated column.
Column = VAR a = SUMMARIZE ( FILTER ( 'Table', CONTAINSSTRING ( [Plan Name], "Fiber" ) ), [Customer ID] ) RETURN IF ( [Customer ID] IN a, "Y", "N" )Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is this an attribut of the Customer? Seems only Customer ID of 23 and 71 are marked Y, all the others N.
Is it as simple as:
[Fiber] = IF ([Customer ID] IN {23, 71 }, "Y", "N" )
?
I couldn't use that formula as there are thousands of account IDs I wouldn't know beforehand which ones would contain what plan name.