cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Fill null value with the previous row value when it's not filled with a value

How to replace the null value with the first year. So row 2,3,4,...,12 should be 2020 and row 14 and 15 should be 2021. And row 1 should remain 2020 and row 13 2021

Thank you for your help!

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Re: Fill null value with the previous row value when it's not filled with a value

@Kpham 

 

Try this!


Transform Tab>fill>down

 

20.PNG

View solution in original post

1 REPLY 1
Highlighted
Helper II
Helper II

Re: Fill null value with the previous row value when it's not filled with a value

@Kpham 

 

Try this!


Transform Tab>fill>down

 

20.PNG

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors