Forum Discussion
Cascade dates
Hi datauser_2025 ,
Thanks for reaching out to us.
Based on your description, you can try filling down after merging.
Here's an example, after merging with the date table, there're blanks.
Select the columns and then fill down.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi datauser_2025 ,
When you do the merge the values will only get pickup for the lines that match, so in this case you get the line for the first of the month filled out.
To achieve what you need you must be sure that your date is sorted by the date column asc so from 1st January to 31st of December, after that go to the columns that are blank and do a fill down that will mark all the values with the above value.
https://learn.microsoft.com/en-us/power-query/fill-values-column