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

    Filtering on last business day of a month

    Christian Schwehm

      Hello,

       

      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 :-)