1 of 1 people found this helpful
I can't save a workbook in your version of Tableau, but hopefully the formula below will be enough. the DATEPART function gives you a numeric value for whatever you choose (day, week, month, year, weekday...), so you can subtract that from the date you're looking at, and then add as many days as you need to get the day you want (so, 6 to get back to the Friday). If you have that as a calculated field, you can drag it to the Detail button, then it will be available to use in your Tooltip, instead of the absolute date.
MAX([Date]) - DATEPART('weekday',MAX([Date]))+6
Thanks a lot its really help me out.
Thanks for taking yours imp times for this.
You're welcome, Rakesh. If your question is now answered, could you click on the "Correct Answer" button in the response, please?