Category: blog-en

  • Year-to-date in Tableau

    If you want to compare last year to this year ‘to date’, you have to take into account that a leap-year adds 1 extra date to the year – so you can’t just compare the day-of-year from this and last year. Often this filter is used: But this is a better one, since this compares day…

  • Calculate last day of month

    ,

    Sometimes you need to calculate how many days a certain month – like the current month. With some nested date-calculations this isn’t that hard to calculate…