Extract text from column and use it as new column

[ttheodoc]

Hello,

I have the following situation. I have a table that contains a column with easily delimited values, that I would like to extract, but then use the values between parentheses as new column values.

Here is what I have:

And here is what I am trying to get:

I have tried doing this from Power Query, where I can create the columns for each type of fault, which looks like this:

But as you can see, the column values are still the old values, whereas I want just the numbers between the parentheses. Either DAX or power query method for me would work.

Any tips on how to achieve this are welcome!

[Greg_Deckler]

@ttheodoc Can you post your sample data as text?

[ttheodoc]

@Greg_Deckler certainly:

Faults	Date
51_62.03 (1) |	01/09/2023
51_62.03 (1) | 53_01.09 (1) | 53_13.04 (1) | 53_25.04 (1) | 53_33.04 (1) | 53_34.04 (1) | 53_47.04 (2) | 53_44.04 (2) | 54_42.04 (2) | 54_17.04 (1) | 54_37.04 (1) | 54_33.04 (1) | 54_57.04 (1) | 53_32.04 (1) | 53_42.04 (1) | 54_22.04 (1) | 54_41.09 (1) | 54_04.04 (3) | 54_15.04 (3) | 53_41.09 (3) | 53_31.09 (1) | 54_31.09 (1) | 54_01.09 (1) |	02/09/2023
51_62.03 (1) | 53_01.09 (2) | 53_02.04 (3) | 53_25.04 (1) | 53_33.04 (3) | 53_34.04 (2) | 53_44.04 (3) | 54_42.04 (2) | 54_52.04 (2) | 54_37.04 (1) | 54_57.04 (1) | 54_19.04 (1) | 53_12.04 (1) | 53_24.04 (1) | 53_32.04 (1) | 53_23.04 (1) | 53_45.04 (2) | 54_41.09 (1) | 54_04.04 (3) | 54_15.04 (4) | 53_31.09 (1) | 53_51.09 (1) | 54_31.09 (1) |	03/09/2023
51_62.03 (1) | 53_01.09 (3) | 53_25.04 (2) | 53_34.04 (4) | 53_44.04 (1) | 53_55.04 (1) | 54_02.04 (1) | 54_42.04 (1) | 54_52.04 (1) | 54_17.04 (1) | 54_37.04 (2) | 54_47.04 (2) | 54_43.04 (2) | 54_44.04 (1) | 54_57.04 (1) | 54_19.04 (1) | 53_12.04 (1) | 53_32.04 (1) | 53_42.04 (2) | 53_43.04 (1) | 53_45.04 (3) | 53_19.04 (1) | 53_07.04 (1) | 54_41.09 (3) | 54_15.04 (2) | 53_21.09 (1) | 53_11.09 (5) | 53_41.09 (3) | 54_51.09 (1) | 54_31.09 (1) |	04/09/2023
51_62.03 (1) | 53_11.09 (1) | 53_31.09 (1) |	05/09/2023
51_62.03 (1) | 54_11.09 (1) | 53_22.04 (1) | 53_44.04 (2) | 54_32.04 (2) | 54_17.04 (1) | 54_37.04 (1) | 53_12.04 (1) | 53_24.04 (2) | 53_42.04 (1) | 54_04.04 (1) | 53_21.09 (1) | 53_11.09 (3) | 53_41.09 (5) | 53_31.09 (1) | 53_51.09 (4) | 54_01.09 (1) |	06/09/2023
51_62.03 (1) | 54_11.09 (1) | 53_34.04 (1) | 54_42.04 (1) | 54_33.04 (1) | 53_32.04 (1) | 53_42.04 (1) | 53_45.04 (3) | 53_17.04 (2) | 54_41.09 (2) | 53_11.09 (2) | 53_31.09 (2) | 54_51.09 (2) |	07/09/2023
51_62.03 (1) | 54_19.04 (1) | 53_17.04 (1) |	08/09/2023
51_62.03 (2) | 54_11.09 (1) | 54_12.04 (1) | 53_02.04 (1) | 53_03.04 (4) | 53_04.04 (1) | 53_37.04 (1) | 53_34.04 (1) | 53_47.04 (1) | 54_32.04 (1) | 54_37.04 (2) | 54_43.04 (1) | 53_42.04 (1) | 53_07.04 (1) | 54_41.09 (2) | 53_11.09 (4) | 53_41.09 (1) | 54_51.09 (1) | 54_21.09 (4) |	09/09/2023

Please let me know if you need any more info!