Forum Discussion

Bando's avatar
Bando
Frequent Visitor
9 years ago
Solved

Edit query not changing format

I'm using edit query to transform data from and Excel table to get the correct formatts for my work. You can see from the query below that the formatting changes seem to be made but when I look at th...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    OK, the data type Percentage doesn't exist in the data model, but you can use decimal number, with format percentage.

     

     

    Alternatively, if you want e.g. 25% to show up as 25 in the data model, you need to multiply the values by 100.

     

     

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

Probably the formats were changed, but the percentage data type in Power Query does not exist in the data model.

 

So e.g. 99% in the Query Editor becomes 0.99 in the data model.

Maybe the data type in the data model was adjusted to whole numbe, causing the 0.99 convert to 1.

Bando's avatar
Bando
Frequent Visitor
9 years ago

Hi thanks for the quick reply but I'm not too sure I understand? What do I need to do to ensure the formats stay changed?

 

Cheers

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    Do you mean the percentages?

    • Bando's avatar
      Bando
      Frequent Visitor
      9 years ago

      Yeah the percentages. Thanks

      • MarcelBeug's avatar
        MarcelBeug
        Community Champion
        9 years ago

        OK, the data type Percentage doesn't exist in the data model, but you can use decimal number, with format percentage.

         

         

        Alternatively, if you want e.g. 25% to show up as 25 in the data model, you need to multiply the values by 100.