Calculating the last 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 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 day of the month in our desired format. For example in the Sample Superstore dataset if we want to view the last 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.
