cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamesSimison
Regular Visitor

Spelling correction

Hi, 

 

we have found a small error in a much used data entry form, some months were shortenend and others were not, January to Jan, February to Feb etc. Before we were able to get the form fixed we were able to add a quick text replace function

 

"= Table.ReplaceValue(#"Changed Type","Jan","January",Replacer.ReplaceText,{"label"})" 

 

to fix the issue in the report side of things. Now the form has been fixed it is replacing January with Januaryuary which is not ideal. 

 

Is there any way to change the Jan and leave the January well alone 

 

Cheers

3 REPLIES 3
parry2k
Super User III
Super User III

@JamesSimison sounds good. Cheers!!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User III
Super User III

@JamesSimison try this expression:

 

Table.ReplaceValue(#"Changed Type", each [label], each if [label] = "Jan" then "January" else [label] ,Replacer.ReplaceText,{"label"})

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Cheers, I managed a work around by using the match entire cell contents in the replace values menu. I'll keep hold of this solution if the way I've used fails in the future. 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors