Power Query formula to get text after last comma - BI Service

[MikeGanem3]

I can do it in Desktop using "Add Column" in "Transform Data" but need to get it done in Service.

If the column value is

        Help, Tips, Tutorial

I need to extract Tutorial and put it in a new column of just display Tutorial in an existing colum whihc is displaying "Help, Tips, Tutorial"

[MikeGanem3]

ever mind!  I have moved on from it.

[v-hashadapu]

Hi @MikeGanem3 , We apologise for the inconvinience and sorry to know it didn't help. Can you please confirm if you issue is solved, if it did, can you please share the insights here and mark your response 'Accept as Solution', so others with similar issues may find it easily.
Thank you.

[v-hashadapu]

Hi  @MikeGanem3 , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

Thank you @Fowmy for your valuable input.

[MikeGanem3]

No, it did not help

[v-hashadapu]

Hi  @MikeGanem3 , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi  @MikeGanem3 , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[Fowmy]

@MikeGanem3 

Under, Add column, use Extract > Text .AfterDelimiter choose the the following options

[MikeGanem3]

I know how to do it in Desktop and already mentioned in my original post, my question was how to do it in BI Service

[v-hashadapu · Accepted solution]

Hi @MikeGanem3 , Thank you for reaching out to the Microsoft Community Forum.

In Power BI Service, you can't modify datasets directly like you do in Power BI Desktop using Power Query, However, you can achieve this using DAX in a calculated column or measure.

1. Example for Column:

NewColumn =

VAR TextList = 'YourTable'[YourColumn]  -- Replace with your actual table and column name

VAR LastValue = TRIM(RIGHT(TextList, LEN(TextList) - FIND("@", SUBSTITUTE(TextList, ", ", "@", LEN(TextList) - LEN(SUBSTITUTE(TextList, ", ", ""))))))

RETURN LastValue

2. Example for Measure:

LastValueMeasure =

VAR TextList = SELECTEDVALUE('YourTable'[YourColumn])

VAR LastValue = TRIM(RIGHT(TextList, LEN(TextList) - FIND("@", SUBSTITUTE(TextList, ", ", "@", LEN(TextList) - LEN(SUBSTITUTE(TextList, ", ", ""))))))

RETURN LastValue

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.