Fixed Decimal number not showing 4 digits after decimal point

Power Query
1

Dear friends, i have seen so many documentation ,every where microsoft mentioned that in power query, if we set data type of a numeric column to be fixed decimal number then we will have always 4 digits to right of decimal point. But i what i can witness it is not the case. in fact it showing just two digits after the decimal point all the time… any information will be appreciated.

regards

2

Hi @praveer82,

You can do it also in Model part with some other features as well - like

image
image203×903 11.5 KB

3

Thanks sir for replying
I know that i can do that in while working on model…i am confused about definition given by
microsoft…why they are saying 4 digits after decimal point.

regards

4

Have you sent a message to Microsoft and ask about it? I’m sure they will reply to your message. :slight_smile:

5

Hi Praveer,
you see only 2 digits in the pq editor, but when you load it you will get the promised 4 digits:

image
image
image

Try it out.

Regards,
Matthias

1 Like
6

No keith not yet… first thought of asking from experts here…
regards

7

just another note if you are using the $dollar format you will get only 2 decimals. you will have use the correct data format “number” in power query

8

Thanks a lot
i verified same …
regards