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

rohitMe's avatar
rohitMe
Advocate I
8 years ago

Hi Anonymous

 

I would suggest you that instead of using the fill down option you create a new custom column defining the criteria according to which you need to fill the cell value.

 

Look at the following problem and solution so you get an idea as to how you can proceed. The solution is I guess not what you are looking for but it should help you to understand what you need to do to acheive your result.

 https://community.powerbi.com/t5/Desktop/Filling-Data-Gaps-Conditionally/td-p/148745

 

Regards

Rohit