Reverse Text For a Specific Language In a Column

[Grosman]

Hello,

I have a column with names written in 2 different languages.

I want to reverse the text only for a specific language out of the 2.

Any possible solution in M code?

Thank you.

[ribisht17 · Accepted solution]

@Grosman 

Please post some data, it won't help much, even then I see it as below

Step 1

Add an INDEX

Solved: Add calculated index column by DAX - Microsoft Power BI Community

Step 2

Now you have 2 columns

INDEX|LANGUAGE

1.English

2.Hindi

3.English

4.Hindi

Step 3

MOD(<number>, <divisor>)

MOD([INDEX],2)

Step 4

Step 3 will give you MOD as below

INDEX|LANGUAGE|MOD

1.English|1

2.Hindi|0

3.English|1

4.Hindi|0

Step 5

Now wherever you see 0, reverse the TEXT

Regards,

Ritesh

[Grosman]

I have no indicator for the language if thats what you mean.

I only have the text itself but i dont know how to dynamically recognize the language and then reverse it only when its english.

[ribisht17]

If there is no indicator then "Not possible"

[ribisht17]

Post some sample dummy data here to see the feasibility

[ribisht17]

@Grosman 

Solved: Reverse Text - Microsoft Power BI Community

Not sure how do we go to specific language, information missing 

For example if we have something like below with delimiter -

Hindi Name-English Name

Step 1

Split into 

Column1|Column2

Hindi Name| English Name

Step2

Apply this to Column Name-2>> Solved: Reverse Text - Microsoft Power BI Community

Last Step

We can combine Column1 and Step2 again with -

Hindi Name|EmaN IdniH

Regards,

Ritesh

Regards,

Ritesh

[Grosman]

I have 2 languages, but each one in a different line so i dont need to split.

I only need to reverse the english lines and not the other language lines.