Forum Discussion
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...
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.
Do you mean the percentages?
Yeah the percentages. Thanks