cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cham Member
Member

Replace the null value with the previous value

Hi,

 

I want to fill my null values with the previous value in that column. 

Ex- null = 1/11/2018 (This column have Novemver month all days and some values are null so i want to get the previous date value for my null values)

 

Null values.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
AlexisOlson Member
Member

Re: Replace the null value with the previous value

In many cases, the handy Fill Down feature under the Transform tab will do the trick.

 

FillDown.png

 

 

View solution in original post

2 REPLIES 2
Highlighted
AlexisOlson Member
Member

Re: Replace the null value with the previous value

In many cases, the handy Fill Down feature under the Transform tab will do the trick.

 

FillDown.png

 

 

View solution in original post

cham Member
Member

Re: Replace the null value with the previous value

Thank You So Much

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 110 members 1,407 guests
Please welcome our newest community members: