4 Replies Latest reply on Mar 14, 2017 10:32 AM by Christian Schwehm

    Filtering on last business day of a month

    Christian Schwehm



      I've got a Problem to filter a list of dates in an appropriate way.

      How can I filter a list of days, so that I only see the last weekday of a month (i.e. no saturday or sunday). Later on I would like to apply a table calculation that gives me the respective return.


      A related question would be to filter the data that gets into the workbook already at the datasource Level. Is there a way to Limit the data at the very beginning? In reality I have a huge amount of daily data, but it would be sufficient to work with the month-end values.


      A Tableau 10.1 Workbook is attached and the Excel-file for the Import is attached.


      Thanks for your help :-)