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.

     

     

     

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

Is this a simple Calculated Column in DAX? Like IF / THEN / ELSE ?

Can you share the logic that would make cetain rows a "Y" and others "N"? Is it based on data from another table?

Just looking at it, I cannot discern what makes a Y versus N. We need more of your business logic.

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

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" )

?

  • Spudonis's avatar
    Spudonis
    Regular Visitor
    1 year ago

    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.