Currently we have data which contains data for every weekday, however no values are available for Sat or Sun. We need to create a few which contains a value for every day of the year. In the case of Sat or Sun the view needs to show the last available data, hence the values from friday.
We have a date table which contains every days date from 1970 to 2030.
For example we have:
We are looking for a solution in a single view.