I have a data source that have some recent dates data missing in the table. I am creating a dashboard to indicate missing date status as red and available as green color. When I pull a date from table, it lists all dates which are in the table (obviously!). I want to pad the date field to show dates which are not in table, that way I would be able to show the status for missing data.
Example, available dates in table are 2/1 to 2/20 and today's date is 2/25, then date column should display all dates from 2/1 to 2/25.