Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
hi, you can also bring me the M function (custom column)
just to see if its solve my problem
thanks
Hi @Jimmy801
this my PBI https://1drv.ms/u/s!AonyYI-TdspHgVUVK2rJpCsY7yoh?e=a2Pm7n
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.