Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I'm trying to reverse the words in english because they came out reversed for example koobecaf should be facebook, here's the catch, there are words in a different language which came out fine so i dont want to reverse those.
My idea is to reverse the cells with english letters only while leaving the other language(a-z, A-Z).
note: the other language does not use latin letters so that should make things easier.
Solved! Go to Solution.
let
Source = Sql.Database(ServerAddress, DbName),
dbo_DVDR_LEADSOURCES = Source{[Schema="dbo",Item="LEADSOURCES"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_DVDR_LEADSOURCES, each ([LEADSOURCE] <> 0)),
Ad_Corrected = Table.AddColumn(#"Filtered Rows", "Corrected", each
if List.ContainsAll({"a".."z", "A".."Z"} & Text.ToList(" .,/*-+=-!~';\/|"), Text.ToList([LEADSOURCENAME]))
then Text.Combine(List.Reverse(Text.ToList([LEADSOURCENAME])))
else [LEADSOURCENAME],
type text)
in
Ad_Corrected
let
Source = Sql.Database(ServerAddress, DbName),
dbo_DVDR_LEADSOURCES = Source{[Schema="dbo",Item="LEADSOURCES"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_DVDR_LEADSOURCES, each ([LEADSOURCE] <> 0))
in
#"Filtered Rows"
this is the code i have, when i tried to add yours it showed an Eof error @dufoq3 @Vijay_A_Verma
let
Source = Sql.Database(ServerAddress, DbName),
dbo_DVDR_LEADSOURCES = Source{[Schema="dbo",Item="LEADSOURCES"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_DVDR_LEADSOURCES, each ([LEADSOURCE] <> 0)),
Ad_Corrected = Table.AddColumn(#"Filtered Rows", "Corrected", each
if List.ContainsAll({"a".."z", "A".."Z"} & Text.ToList(" .,/*-+=-!~';\/|"), Text.ToList([LEADSOURCENAME]))
then Text.Combine(List.Reverse(Text.ToList([LEADSOURCENAME])))
else [LEADSOURCENAME],
type text)
in
Ad_Corrected
Hi @545, you can try something like this
If you want to ass more characters to include in correction, you can add them into pink box
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKqlILVHIKM7MSc9zVYrViVbKzs9PSk1OdANzchOL0hNLivM8wbz0tJTiI71HFx5dCiLBQkf2HV0IFAWiwwuPLjy8FohXKsXGAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
Ad_Corrected = Table.AddColumn(Source, "Corrected", each
if List.ContainsAll({"a".."z", "A".."Z"} & Text.ToList(" .,/*-+=-!~';\/|"), Text.ToList([Column1]))
then Text.Combine(List.Reverse(Text.ToList([Column1])))
else [Column1],
type text)
in
Ad_Corrected
Need examples of some sample data.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
6 | |
6 | |
6 | |
6 |
User | Count |
---|---|
9 | |
9 | |
8 | |
6 | |
6 |