Forum Discussion
User5231
Helper II
Helper IIPeg through levels
order converted order serial number calculated serial number abuk wdca 1 1 wdca azda 1 azda wdel 1 wdel ahjt 1 I'm trying to find a way to calculate t...
Hi User5231 ,
Please check the formulas.
Parent_ = LOOKUPVALUE('Table'[converted order],'Table'[converted order],'Table'[order])path_ = PATH('Table'[converted order],'Table'[Parent_])&"|"group_ = var position = FIND("|",'Table'[path_]) return LEFT('Table'[path_],position-1)calculated serial number = CALCULATE(SUM('Table'[serial number]),FILTER('Table','Table'[group_]=EARLIER('Table'[group_])))Best Regards,
Jay
User5231Helper II
Helper IISorry, let me explaing.
Abuk became wdca and was serial number 1.
wdca because azda then wdel then ajht.
How do you step through that without explictly loking up the value and calling out each new level as a coumn or stored variable. Can it be looped?
- danextian
Super User
abuk became wdca
wdca became azda
azda became wdel
wdel becahme ahjttheir calculated serial number is 1 because the initital serial number prior to further conversion was 1. Is my understanding correct?
