Forum Discussion
DAX help
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
1 Reply
Please see this article for a function that does that.
Guest Post: Using List.Accumulate for Input/Output Genealogy – The BIccountant
Pat
