filling blanks with previous column text

[Sushmach109]

Hi team,

I need to fill the current blanks values with previous row data.

I tried but able to find the solution.Can you please try to give Solution.

Colulmn1

A

null

null

B

null 

null

Expected Result

Column

A

A

A

B

B

B

Thanks,

[v-yulgu-msft · Accepted solution]

Hi @Sushmach109,

Add an index column first.

Create a calculated column with below DAX formula.

Required Result =
IF (
    Table_1[Column2] = BLANK (),
    CALCULATE (
        LASTNONBLANK ( Table_1[Column2], 1 ),
        FILTER ( Table_1, Table_1[Index] < EARLIER ( Table_1[Index] ) )
    ),
    Table_1[Column2]
)

Best regards,

Yuliana Gu

[Sushmach109]

Thanku.

[vanessafvg]

@Sushmach109  you can use the fill down function in query editor

go to the transform menu on the ribbon and select fill  and then down

[Sushmach109]

This is very dynamic and is not one time transformation.

What is equalent dax formula for this?

Column1 Column2     Required Result

ticket1     A                 A

ticket1    null               A

ticket1    null               A

ticket2    B                   B

ticket2    null               B

ticket2    null               B

ticket2    C                   C

ticket2    null                C

Thanks,

[vanessafvg]

@Sushmach109 the solution i posted is dynamic, whatever data is loaded will have that applied to it everytime