The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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"
Solved! Go to 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.
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
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.
ever mind! I have moved on from it.
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.
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.
No, it did not help
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.
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.
@MikeGanem3
Under, Add column, use Extract > Text .AfterDelimiter choose the the following options
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
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.
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
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.