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
Super 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.

Spudonis's avatar
Spudonis
Regular Visitor
1 year ago

Apologies. I had that included in the post originally but the forum gave an error and removed it.

 

I'm trying to have it search for any row that contains the word "Fiber" and then make the new column "Y" if it is true but it has to apply that "Y" to all instances of that Customer ID.

 

It might be a simple IF, THEN, ELSE but I don't know enough to know if that would work or not. I couldn't get it to work to apply to each row with that account ID.