Show future dates with that don't have data in dataset

Question & Answer
, ,
2

Hello @Winojoe, welcome to the QuickSight Community!

You may be able to make this work by replacing your date field with an ifelse statement. Something like this:

ifelse(
  extract('YYYY', {date}) = 2023,
  dateAdd({your_date_column}, 1, 'YYYY'),
  {date}
)

Then it should display the full month of dates, even if the full month for 2024 hasn’t been completed. It may require some extra filters based on if you only want January to show, but this should get you the result you are looking for! Let me know if you have any further questions on this.

1 Like