Rounding to nearest number in Power Query when i dont want to

[Tobiasahansen96]

Hi all, 

I have a dataset like the one below: 

When looking at the column "total_amount" i have certain values that have decimals after the figure. 

Then when looking in the column "amount_EUR" these numbers suddenly do not have any decimals? 

The amount_EUR just takes the value in total_amount if this value is of currency EUR. 

How do i keep the decimals numbers from total_amount to amount_EUR? Both columns are of data type "Fixed Decimal number"

[Greg_Deckler]

@Tobiasahansen96 What is your formula for amount_EUR?

[Tobiasahansen96]

The formula in Power Query are:  

Added Custom" = Table.AddColumn(#"Renamed Columns2", "amount_EUR", each [total_amount]*[rate_to_eur]/100)

[Greg_Deckler]

@Tobiasahansen96 Bizarre, I can't replicate that behavior. See PBIX attached below signature.

[Tobiasahansen96]

It is fixed now - a mistake from my side by having a chaned type right to a whole number right after addin the extra column...

[Greg_Deckler]

@Tobiasahansen96 Those Change types will get you!

[Tobiasahansen96]

Seems very weird 🤔