DAX help

[Anonymous]

Hi 

Please can you help me to derive below Output from left side Input table.

Logic is 

L1 = if WO is not in associate wo
L2 = check L1 against WO and find associate WO 
L3 = check L2 against WO and find associate WO
L4= check L3 against WO and find associate WO

loop will continue until it doesn't find next value in WO

[ppm1]

Please see this article for a function that does that.

Guest Post: Using List.Accumulate for Input/Output Genealogy – The BIccountant

Pat