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,