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

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.