Forum Discussion

paisely's avatar
paisely
Frequent Visitor
8 years ago
Solved

Identify round values in a column

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's avatar
    Anonymous
    8 years ago

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

     

     

  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    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.

6 Replies

  • paisely's avatar
    paisely
    Frequent Visitor
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

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

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    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.