Return multiple hits

[scr5jo]

Hi Guys,

I have a table that manages my masterdata. In that table is the material number, and the last successor
To explain, I will use an example, and in this case materials A,B,C and D are all superseded to the new material E
So we could have something that looks like this

Material Last Successor
A E
B E
C E
D E
E E

I need a query that allows me to enter any material and get all the other options listed to return.
So if I enter A,B,C,D or E, then I get the query to return all materials A,B,C,D and E

Any ideas how I could achieve this?
thanks

 

[mart37]

You can use functions like:
MATCH (search MATERIAL - if unique!)
INDEX (find LAST SUCCESSOR)
FILTER (list of MATERIAL of LAST SUCCESSOR)

 

[scr5jo]

thanks, but these are excel functions. I'm looking for the PowerBi Dax versions.
can you help?