Forum Discussion

User5231's avatar
User5231
Helper II
4 years ago
Solved

Peg 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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

User5231's avatar
User5231
Helper II
4 years ago

I think the solution here will be using the path functions. I'll test it out and see.