Forum Discussion
jmiridium
Helper IV
Helper IVRemove Decimals In Table
I want to show whole numbers. By default I have two decimal places in my table with numbers. How do I remove the decimal?
You can go to the data view, select the appropriate column, and then select the Modeling ribbon and then formatting tab. You can either change to a Whole Number or reduce Decimal Number to show 0 decimal places.
How would i remove decimals if im using direct query
I might be answering this question too late, goto Edit query->Transform -> Data Type -> Fixed decimal number . The value changes from type number to the accounting type($) . Right click on the variable,->transform -> round to remove the decimal points.