Identify round values in a column

[paisely]

I am new to PowerBI and would appreciate any assistance with a query to identify round values in a column of numbers. The data type for the column is "decimal number". Please provide steps that would identify all values that is rounded off in the 1000's. For example, 1000, 2000...10,000,100,000, etc. Thank you in advance for your assistance.

[Anonymous · Accepted solution]

Include a column and try this formula-IsMod1000 = IF(MOD(Table1[Column1],1000)=0,"Yes","No")

[v-xjiin-msft · Accepted solution]

@paisely

I'm not quite understand about your requirement as identify all values that is rounded off in the 1000's.

If you mean that your decimal numbers have been rounded before importing into Power BI desktop. And you want to identify these already rounded numbers in Power BI to find out the 1000's. I'm afraid it is not possible in current Power BI.

If you want to format decimal numbers in Power BI to make them be rounded and find out the 1000's. You can refer to following steps:

1. Create a calculated column and Round() function to round decimal numbers. 

Round number = ROUND(Table6[Column1],0)

2. Then you can use Mod() function to calculated the 1000's.

1000's = IF(MOD(Table6[Round number],1000)=0,Table6[Round number],0)

If I misunderstand your requirement, please feel free to correct me. Also, please share us some sample data and your desired result. It will help us more to understand your requirement.

Thanks,
Xi Jin.

[paisely]

Hi,

I am new to PowerBI and am looking for assistance with identifying numbers in a column that is rounded off in the 1000's. The data type for this column is decimal number. Any assistance would be appreciated.

[Anonymous · Accepted solution]

Include a column and try this formula-IsMod1000 = IF(MOD(Table1[Column1],1000)=0,"Yes","No")

[Anonymous]

[paisely]

Would i add a custom column to enter this formula in the queries page?

[Anonymous]

yes you need to add a custom column