Pulling down rows like in excel?

[telusive]

I guess I don't know how to google this properly. I was hoping to not force my people into pulling this down in excel, but if it must be done, it must. 

If I wanted the below to show 1/2/2024 for all the nulls AFTER 1/2/2024, then fill the nulls AFTER 1/8 with 1/8, is there some way to achieve this in Power Query?

[telusive]

Thanks! I knew it had to be somewhere, since it's so easy in excel!!!

[Tahreem24 · Accepted solution]

@telusive , Please follow the below steps:

Step 1: This is the sample I have taken

Step 2: Select the Date column and go to Transform --> Fill --> Down

Step 3: Final Result