Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Help: formula find or search

Hello!! Im new in PBI, I want someone could help me with this:   I have a column that calculates with numbers that have two decimals, I need (without considering the decimals) to take the last thr...
  • ricardocamargos's avatar
    ricardocamargos
    8 years ago

    Hi Anonymous,

     

    Try this code creating a new column:

    Test = IF(RIGHT(INT(Table1[Column1]); 3) = "000"; 1; 0)

     

    After that you can filter the report or page by this new column.

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi!!!

Thanks.

 

This is the scenario:  I have a colum with number like:  12,345.89, 673,000.76, 8700.00, 34,000.00 etc. And I need only the records when the last three digits before the dot, are 0; for example from this list; I only should show 673,000.76 and 34,000.00 (this two numbers have three digits cero, before de dot.

 

I dont know how to do that.

ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

Hi Anonymous,

 

Try this code creating a new column:

Test = IF(RIGHT(INT(Table1[Column1]); 3) = "000"; 1; 0)

 

After that you can filter the report or page by this new column.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for the help!!! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Im not sure if I can ask here for another or in a new post.

     

    For the same situation, if I only want to show 30 rows (the 30 bigger), is possible to add this in the same Column?

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      8 years ago

      Hi Anonymous,

       

      You 'd better create a new post for a new question.

       

      That will be convenient for people who may have the same question can get the solution directly.

       

      Best Regards,

      Cherry