Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
Thanks! I knew it had to be somewhere, since it's so easy in excel!!!
@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