3 Replies Latest reply on May 5, 2018 6:13 AM by kumar bharat

    MAX(YEAR) ON TOP OF CUBE

    Ab Adi

      Hey Guys,

       

      I am sure we all know that we dont have the ability to create a calculated field with dimensions from a multi dimensional data source . Is there a way we can allow cube dimensional values in calculation .

      I believe we can create a calculated member and then write MDX . can anyone help me with MDX query to get the max of year in Tableau. i want to take the latest year .

       

      Dimension - Year

      Measure -  Revenue