Reputation: 81
How to remove decimals without rounding in Power query?
Thanks.
Upvotes: 0
Views: 222
Reputation: 21428
Add column, custom column
= Number.IntegerDivide([ColumnNameHere],1)
or transform the column to remove decimals
= Table.TransformColumns(#"PriorStepNameGoesHere",{{"ColumnNameGoesHere", each Number.IntegerDivide(_,1),type number}})
or transform data type of column to whole number
Upvotes: 1