Help: formula find or search

[Anonymous]

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 three digits and if these are zeros (the three) take the thirty largest ones, for example
Colum
LC
100100.45
2345000.00
34000.10
123000.00

I should return the 2nd, 3rd and 4th and those sort from highest to lowest and return the first 30 records.

Thank you very much for your help
Monica

[Anonymous]

Hi @Anonymous

I am trying to undeerstand, but sorry, couldnet get your question. Could you please explain what logic you want?

Thanks

Raj

[Anonymous]

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]

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

[ricardocamargos · Accepted solution]

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]

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]

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

[Anonymous]

Thanks for the help!!!