Need Help

HI Gabriel_Largura ,

Try using Text Search custom visual in Power BI to search for a value:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview

Thanks,

Pragati

Hi  Gabriel_Largura ,

First create a table as below:

Table 2 = VALUES('Table'[Prox Ponto])

Then create a measure as below:

Measure = 
IF(MAX('Table'[Indice]) in FILTERS('Table 2'[Prox Ponto]),MAX('Table'[Indice]),BLANK())

Finally create a table as you need:

Table 3 = UNION(ROW("Result","35311-512776-512777"),FILTER(VALUES('Table'[Indice]),'Table'[Indice]='Table'[Measure]))

And you will see:

For the related .pbix file,pls see attached.

thank you v-kelly-msft 
but still not the desired result...

I would like a result "similar" to this calculation

'tableresult' = 

line 1 = "35311-512776-512777"

line 2 = lookupvalue('table'[Prox Ponto],'table'[Indice],line 1)
line 3 = lookupvalue('table'[Prox Ponto],'table'[Indice],line 2)
line 4 = lookupvalue('table'[Prox Ponto],'table'[Indice],line 3)
.....

WHILE lookupvalue('table'[Prox Ponto],'table'[Indice],line X) <> BLANK()

hello,

it is not correct, the values ​​are different

hello v-kelly-msft , thanks for helping me!

Attached the calculation in excel and the data source, some (Prox Ponto) may be blank, it's ok.

https://drive.google.com/drive/folders/17RlVn6JdcOPzjKz2Ed0FxXMvY07cl9Cn?usp=sharing