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.

  • Revathy's avatar
    Revathy
    New Member
    10 years ago

    Hi..

     

    Didn't find the text.combine function in the dax query..can u please help

    • greggyb's avatar
      greggyb
      Resident Rockstar
      10 years ago

      Text.Combine is an M function available in Power Query, the ETL tool included in Power BI. DAX is the query language for Power Pivot/SSAS Tabular, the modelling and analytical engine in Power BI.

       

      You can use Text.Combine in the get data portion of Power BI if you choose to edit the query.