Forum Discussion
Helper IPower Query formula to get text after last comma - BI Service
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"
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.
- 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
- 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.
9 Replies
- Fowmy
Super User
MikeGanem3I 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-hashadapuCommunity Support
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.
- 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
- 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.
- 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. - 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
- 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.
