Forum Discussion

Ivo_Kessler's avatar
Ivo_Kessler
Regular Visitor
4 years ago
Solved

Populate column based on single value from other column

Hi all,   I have a problem I already tried a lot to solve it but can´t find a solution. In the table below "Entry No_" is a index value. What I already figured out was how to populate "ILE 1". Th...
Need Help
  • Ivo_Kessler's avatar
    Ivo_Kessler
    4 years ago

    Hi,

     

    Power Query would just be to slow... the table is pretty big (almost 1.4 millon lines and growing).

    I figured it out on how I can do it in a calculated column:

     

    ILE 2 =

    Var ILE_NR =
    CALCULATE (
    MAX ( 'F_Item Ledger Entries'[Entry No_] ),
    ALLEXCEPT ( 'F_Item Ledger Entries', 'F_Item Ledger Entries'[Serial No_] ), 'F_Item Ledger Entries'[Status] = "Scrap"
    )
    RETURN
    if (ILE_NR >= [Entry No_], ILE_NR, BLANK())
     
    Thanks anyway.
    Ivo
lbendlin's avatar
lbendlin
Super User
4 years ago

Does it have to be a calculated column or can it be done in Power Query?