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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

Use this formula to create a new column and filter by 1 to get the desired result.

 

Flag_Column = IF( MOD(TRUNC(Table1[Column1]),1000)=0,1,0)

 

Thanks

Raj