Forum Discussion

daouddajani's avatar
daouddajani
New Member
11 years ago
Solved

Reverse Text

is thier a way to flip (reverse) the contant of a field i.e volumn x has the value 12345 i need it to be displayed 321
  • curth's avatar
    curth
    11 years ago

    Are you reversing and truncating or just reversing? You can reverse text in M by saying

    Text.Combine(List.Reverse(Text.ToList("12345")))

curth's avatar
curth
Power BI Team
11 years ago

Are you reversing and truncating or just reversing? You can reverse text in M by saying

Text.Combine(List.Reverse(Text.ToList("12345")))

Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 years ago

Brilliant, missed that Text.ToList function when I scanned through the list of functions. Nice and clean.