Forum Discussion

telusive's avatar
telusive
Frequent Visitor
2 years ago
Solved

Pulling down rows like in excel?

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?

 

Need Help
  • Tahreem24's avatar
    Tahreem24
    2 years ago

    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

     

2 Replies

  • telusive's avatar
    telusive
    Frequent Visitor
    2 years ago

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

  • Tahreem24's avatar
    Tahreem24
    Super User
    2 years ago

    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