Forum Discussion

Gabriel_Largura's avatar
Gabriel_Largura
Frequent Visitor
5 years ago

Need Help

I have the table below:     and I need to generate a new table where I define the value of line 1 and the others are searched in the column 'Prox Ponto', below an example   Result ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

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.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!