Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Fill down collumn information based on condition

Greeting, everyone, For couple of days can't figure out how I should approach this and got stuck in a corner. I would like to conditionally fill down the (2) collumns infromation based on crite...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Anonymous

    Thanks to rohitMe’s suggestion, I make a test and it seems to achieve your requirement.

    New Antrte = 
IF (
    Sheet1[Antrate] = BLANK (),
    CALCULATE (
        LASTNONBLANK ( Sheet1[Antrate], Sheet1[Antrate] ),
        FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Vartotojas] ), Sheet1[Imone] = EARLIER ( Sheet1[Imone] ) )
    ),
   Sheet1[Antrate]
)

    New Kontaktas = 
IF (
    Sheet1[Kontaktas] = BLANK (),
    CALCULATE (
        LASTNONBLANK ( Sheet1[Kontaktas], Sheet1[Kontaktas] ),
        FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Vartotojas] ), Sheet1[Imone] = EARLIER ( Sheet1[Imone] ) )
    ),
   Sheet1[Kontaktas]
)

    Best regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

Thanks to rohitMe’s suggestion, I make a test and it seems to achieve your requirement.

New Antrte = 
IF (
    Sheet1[Antrate] = BLANK (),
    CALCULATE (
        LASTNONBLANK ( Sheet1[Antrate], Sheet1[Antrate] ),
        FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Vartotojas] ), Sheet1[Imone] = EARLIER ( Sheet1[Imone] ) )
    ),
   Sheet1[Antrate]
)

New Kontaktas = 
IF (
    Sheet1[Kontaktas] = BLANK (),
    CALCULATE (
        LASTNONBLANK ( Sheet1[Kontaktas], Sheet1[Kontaktas] ),
        FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Vartotojas] ), Sheet1[Imone] = EARLIER ( Sheet1[Imone] ) )
    ),
   Sheet1[Kontaktas]
)

Best regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thats amazing!

    I almost got it working as well - with some bugs but was sufficient.

    This however does it perfectly.

    Thank you for your time v-juanli-msft and Everyone!