Identify round values in a column

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

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.