Calculating the last Business day of the month is often a useful scenario during periodic calculations. Calculations which include comparison or end of the month figures often use last business day of the month date in various logical expressions. Using Tableau we can achieve the same by creating a Calculated field which returns the last business day of the month in our desired format.
For example in the Sample Superstore dataset if we want to view the last Business day of the month for each Order Date dynamically, we can do it like below. It goes a month forward, then subtracts a day and returns the date dynamically excluding Saturday (day of week value 7) and Sunday (day of week value 1). Example 29th Jan 2010 was a Friday, so instead of 31st Jan 2010 (Sunday) it returns 29th Jan 2010 (Friday) as the last Business day of the month.
