Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
telusive
Frequent Visitor

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?

telusive_0-1710948541006.png

 

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@telusive , Please follow the below steps:

 

Step 1: This is the sample I have taken

Tahreem24_0-1710949317192.png

 

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

Tahreem24_1-1710949371061.png

Step 3: Final Result

Tahreem24_2-1710949411126.png

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

2 REPLIES 2
telusive
Frequent Visitor

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

Tahreem24
Super User
Super User

@telusive , Please follow the below steps:

 

Step 1: This is the sample I have taken

Tahreem24_0-1710949317192.png

 

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

Tahreem24_1-1710949371061.png

Step 3: Final Result

Tahreem24_2-1710949411126.png

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.