Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
@Tobiasahansen96 What is your formula for amount_EUR?
The formula in Power Query are:
Added Custom" = Table.AddColumn(#"Renamed Columns2", "amount_EUR", each [total_amount]*[rate_to_eur]/100)
@Tobiasahansen96 Bizarre, I can't replicate that behavior. See PBIX attached below signature.
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...
@Tobiasahansen96 Those Change types will get you!
Seems very weird 🤔