4 Replies Latest reply: Mar 27, 2018 2:24 PM by Stewart Sims RSS

    Max Date as Dimension

    Stewart Sims

      I want to calculate the max date to use as a dimension.  The other discussion I have seen around this only address this calculation as a measure (as far as I can tell)

       

      DateDate(Max(Date),'YYYY-MM-DD')
      2018-03-012018-03-03
      2018-03-022018-03-03
      2018-03-032018-03-03

       

       

      If I use this cacluation as a measure in a table, I get the expected result.  But if I calculate it as a dimension, it gives me an invalid dimension error.  I need to calculate it as a dimension to use on an axis of a bar chart.