Martin
Martin

Reputation: 81

Remove Decimals without Rounding Power Q

How to remove decimals without rounding in Power query?

Thanks.

Upvotes: 0

Views: 222

Answers (1)

horseyride
horseyride

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

Related Questions