8 Replies Latest reply on Sep 15, 2019 3:08 PM by Richie Gimmel

    Table Calculation with LOD expression and IF statement

    Maxime Kehon

      Hello Tableau Community,

       

      I am struggling with a table calculation using LOD expression and an IF statement.

       

      Below is my data-set, I would like to calculate the MAX of each SOW for a specific date range (between 01/31/2015 and 03/31/2015).

       

       

      The formula { FIXED [Sow Id]: MAX([SOW Value])} is working perfectly until I add the condition to it.

       

      See the screen below...

       

       

      If somebody has any hint please let me know.

       

      PS: I do not want to use filters because I will not be using only one measure.

       

      Thank you very much in advance,

      Cheers,

       

      Maxime