Chihiro
Excel Ninja
Can those of you that have PowerQuery test following? I'm seeing unexpected result when using Int64.From() with third argument for RoundingMode.
In sheet:
1. List numbers from -2 to 2 increment number by 0.25 each row (header: Num).
2. In next column enter =INT(A2) and copy down. (header: Int)
3. Load to PQ
In PQ Editor:
Add custom columns with following formulas.
What result do you get? Does all custom columns return same result? Or different?
In sheet:
1. List numbers from -2 to 2 increment number by 0.25 each row (header: Num).
2. In next column enter =INT(A2) and copy down. (header: Int)
3. Load to PQ
In PQ Editor:
Add custom columns with following formulas.
Code:
=Int64.From([Num],null,RoundingMode.Down)
Code:
=Int64.From([Num],null,RoundingMode.ToEven)
Code:
=Int64.From([Num],null,RoundingMode.TowardZero)
Code:
=Int64.From([Num],null,RoundingMode.Up)
What result do you get? Does all custom columns return same result? Or different?