Forum Discussion
Change exisiting text type to decimal
Hi everybody
I am a beginner of powerbi and what to set up a new report in our company. I know that you can change the type of columns but I haven't figure out, how to have an exisiting column as type "text" and change it to type "decimal" with two characters after comma.
Just to make it a little bit clearer:
1. Is 04909 ---> should be 49,09
2. IS 04906 ---> should be 49,06
3. Is 04711 ---> should be 47,11
4. .....
I tried also to transfer at first step to whole number and then to decimal. --> Did not work
As I want to change this in the query Editor and not in the Excel (This is the source of the column).
Can u maybe help me out? 🙂
Thank guys.
Br, mincii
"I tried also to transfer at first step to whole number and then to decimal. --> Did not work"
What happened?
This is the right way to do it.
Change type to number or decimal.
It looks like you want to divide by 100 and use a comma as a decimal separator so try that.
2 Replies
"I tried also to transfer at first step to whole number and then to decimal. --> Did not work"
What happened?
This is the right way to do it.
Change type to number or decimal.
It looks like you want to divide by 100 and use a comma as a decimal separator so try that.
Oh jes, just thought wrong. Thanks for the hint, got it.
