Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Decimal to Text

Hello everybody,   I am trying to load an Excel-Sheet into Dataverse, with a variety of Datatypes, via Dataflow. But i want to load all off them as plain text. All transformational steps should be ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous Maybe Number.Round with 2 decimal places?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have seen this formular earlier, but round ist not really working on text? Or do you mean on the secound flow, that is converting the "long text value" into an actual decimal?
How can i include this formula in converting text to rounded decimal?

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous Well, in Power Query the way it is shown is that it is either text or numeric (ABC 123) in header. So, maybe doing an explicit transformation to text would be the answer so that the header shows just ABC. You could potentially do the Round before the transformation to text but it may not be necessary if you explicitly transform it to text.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Transforming from "Any" to "text" does not help. But the decimal places appear allready in the Query, instead of only in the data table.