8 Replies Latest reply on Aug 1, 2018 2:44 AM by Dileep Reddy

    How to change Max Period Date to today ??

    Dileep Reddy

      Hi Tableau Geeks,

       

      I have date column which i am using for 2 purposes. In 1 sheet, I'm using as a date range filter where it will show Start & End Date. In another Sheet applied as a single value drop down on desc order.

       

      Up to here i was successful and then comes the problem of whenever i open the dashboard it is not loading the Max value as default. But my client was adamant to display the same. So i tried with below cal and it is throwing error.

       

      If MAX([Period_Date]) = Today() Then  Today() else [Period_Date] END.

       

      and i was clueless about this and looks like i was missing something here.

       

      I want to write the calculation to handle this.

       

      Please help me.