Forum Discussion

Spudonis's avatar
Spudonis
Regular Visitor
1 year ago
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"...
General Comment
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

 

 

 

Spudonis's avatar
Spudonis
Regular Visitor
1 year ago

Thank you very much for this! I modified it slightly due to needing it to be case sensitive for the search but this worked wonders!

My code (thanks to you)

Fiber=
VAR a =
    SUMMARIZE(
        FILTER('Table',ISNUMBER(FIND("Fiber",'Table'[Plan Name],1,BLANK()))),'Table'[Customer ID]
    )
RETURN
    IF('Table'[CustomerID] IN a, "Y", "N")