I have a data, like -
I want to show the output like:
Basically, The date range can be created with master calendar (that's fine), but I need to assign the value of each blank MonthYear with its previous non empty value.
How to do this? Thanks in Advance!!
Load the data, create calendar. Create a resident of your original table and construct a new table like below.
if(isnull(Sales),Peek(Sales),Sales) as Sales
order by Date;
Drop Table Data;
Hope this will help.