Forum Discussion

kylee_anne's avatar
kylee_anne
Helper II
2 years ago
Solved

Fill Down Problem

My data is imperfect and I have a column containining area and discipline values.  So I can keep both I thought if I copied the column, replaced discipline with blank or null, then filled down I coul...
Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi,

    Add a new column

    if Text.StartsWith([WBS], "WBS") then [WBS] else null

     or

    if [Level]<3 then [WBS] else null

     then Fill Down

     

    Stéphane

slorin's avatar
slorin
Super User
2 years ago

Hi,

Add a new column

if Text.StartsWith([WBS], "WBS") then [WBS] else null

 or

if [Level]<3 then [WBS] else null

 then Fill Down

 

Stéphane

kylee_anne's avatar
kylee_anne
Helper II
2 years ago

Thanks.  Just for my understanding so if I add a little code to Power Query it works.  If I try to do it all visually it doesn't.  Does it always work this way?