Forum Discussion

mvgust's avatar
mvgust
Icon for Helper III rankHelper III
4 years ago
Solved

Conditional Fill Down

I'm working with a WBS structure that does not have parent entity/child entity columns. I still need to break down the WBS structure by Levels (00.00=Level 2, 00.00.00=Level 3, 00.00.00.00=Level 4) W...
Need Help
  • mvgust's avatar
    mvgust
    4 years ago

    Thank you for your suggestion, however fill down doesn't work as it would associate a record of 000.01.01 to 000.02 in the Level 3 column. I figured out a solution, although it does require more steps and feels like more of a hack than anything else but it works. I added a custom column with the below formula:

    let level3num = Text.BeforeDelimiter([Level 3],".",1),
    level2num = Text.BeforeDelimiter([Level 2]," "),
    compare = if Value.Compare(level3num,level2num)=0 then [Level 3] else null

    in compare


    I then created the heirarchy.

mvgust's avatar
mvgust
Icon for Helper III rankHelper III
4 years ago

Thank you for your suggestion, however fill down doesn't work as it would associate a record of 000.01.01 to 000.02 in the Level 3 column. I figured out a solution, although it does require more steps and feels like more of a hack than anything else but it works. I added a custom column with the below formula:

let level3num = Text.BeforeDelimiter([Level 3],".",1),
level2num = Text.BeforeDelimiter([Level 2]," "),
compare = if Value.Compare(level3num,level2num)=0 then [Level 3] else null

in compare


I then created the heirarchy.