cancel
Showing results for
Did you mean:
Helper I

## filling blanks with previous column text

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,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: filling blanks with previous column text

Hi @Sushmach109,

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Super User I

## Re: filling blanks with previous column text

@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

Proud a to be a Datanaut!
Helper I

## Re: filling blanks with previous column text

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,

Super User I

## Re: filling blanks with previous column text

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

Proud a to be a Datanaut!
Highlighted
Microsoft

## Re: filling blanks with previous column text

Hi @Sushmach109,

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

## Re: filling blanks with previous column text

Thanku.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors