Forum Discussion
Cascade dates
Hello!
I am trying to exapnd a target table to cascade the targets down to the weekly level from the monthly level. However, when I do a merge with my date table, it is returning blanks for all weeks that aren't the first of the month. How can I get the target table to expand to the weekly level with the appropriate targets?
Thanks!
Current Table:
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
2 Replies
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
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
