Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a two subjects like "${Recipient.lead.companyname[0]!""} | Efficiency meets affordability with Microsoft 365 for nonprofits" and "Efficiency meets affordability ${Recipient.lead.companyname[0]!""} | with Microsoft 365 for nonprofits". I have to remove this text "${Recipient.lead.companyname[0]!""} |" and show remaing text.
Kindly help me to achecive this.
Thanks & Regards,
Vamsi Krishna
Solved! Go to Solution.
Hi Tahreem,
Thanks for your reply. I have used replace option in transform data then my problem is solved.
Hello @VamsiKrishna98 ,
one of the things that you can do is to right click on the value in power query and replace it with the value you want.
https://learn.microsoft.com/en-us/power-query/replace-values
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Thanks for your response. Can we acheive this with any dax formula.
@VamsiKrishna98 Try this DAX column:
In the screenshot for second subject in output this text "Efficiency meets affordability" is missing.
@VamsiKrishna98 Try creating a column like below:
Hi Tahreem,
Thanks for your reply. I have used replace option in transform data then my problem is solved.
Hello @VamsiKrishna98 ,
yes, but you should create a new column that says the following:
new column =
IF (
columnName = "${Recipient.lead.companyname[0]!""} | Efficiency meets affordability with Microsoft 365 for nonprofits",
"Efficiency meets affordability with Microsoft 365 for nonprofits",
IF (
columnName = "Efficiency meets affordability ${Recipient.lead.companyname[0]!""} | with Microsoft 365 for nonprofits",
" with Microsoft 365 for nonprofits",
columnName
)
)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
We have many many different subjects like that. It's difficult to add each time when we get new subject to formula. Is there a way by automatically removing this piece of text "${Recipient.lead.companyname[0]!""} |".
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |