Find whats different between elements of a string

Hi,

Thanks for the solution rajendraongole1  provided, and i want to offer some more information for user to rerfer to.

hello rlfRodrigo , you can refer to the following calculated column.

Column = 
VAR a =
    SELECTCOLUMNS (
        ADDCOLUMNS (
            GENERATESERIES ( 1, PATHLENGTH ( [A] ), 1 ),
            "Value_A", PATHITEM ( [A], [Value] )
        ),
        "ValueA", [Value_A]
    )
VAR b =
    SELECTCOLUMNS (
        ADDCOLUMNS (
            GENERATESERIES ( 1, PATHLENGTH ( [B] ), 1 ),
            "Value_B", PATHITEM ( [B], [Value] )
        ),
        "ValueB", [Value_B]
    )
RETURN
    CONCATENATEX ( EXCEPT ( a, b ), [ValueA], "|" )

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.