Data left to right

[netanel]

Hello everyone!

My data comes from left to right (in Hebrew you read from right to left)

Anyone know how to change them so that they come from right to left?

[Jimmy801]

Hello @netanel 

you can transform you column (you could basically also add a custom column, but that would only make more unneccessary data) and apply the function in my code

    Reverse = Table.TransformColumns
    (
        #"Changed Type",
        {
            {
                "YourColumn",
                each Text.Combine(List.Reverse(Text.ToList(_))), 
                type text
            }
        }
    )

if you need more columns to be transformed, you have to add a another nested list. In case I can show you that too. Here a complete code example to see how it works

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckxKVkhJTbNXitWJVvLPSFSoSElUio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [YourColumn = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"YourColumn", type text}}),
    Reverse = Table.TransformColumns
    (
        #"Changed Type",
        {
            {
                "YourColumn",
                each Text.Combine(List.Reverse(Text.ToList(_))), 
                type text
            }
        }
    )
in
    Reverse

transforms this

into this

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[netanel]

hi, you can also bring me the M function (custom column)

just to see if its solve my problem

thanks

[netanel]

Hi @Jimmy801 

this my PBI https://1drv.ms/u/s!AonyYI-TdspHgVUVK2rJpCsY7yoh?e=a2Pm7n

[netanel]

Hi @Jimmy801 

Thanks for the response

Are you mean to put the code in the formula like I did?

It does not work for me

[Jimmy801]

Hello @netanel 

what datasource you are accessing? The solution is in power query - as a query - not in DAX. SO you have to change your datasource quering and transform there your data.

BR

Jimmy

[netanel]

Hi @Jimmy801 

My Datasource is excel file.

I'm a little new to writing code, am I doing something wrong?
Because it does not work for me

[Jimmy801 · Accepted solution]

Hello @netanel 

you are almost there. Just replace the changed type at the very end of your code with Reverse. Be aware, its case sensitive...

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy