4 Replies Latest reply on Jul 22, 2018 9:10 PM by Vijay Kulkarni

    Sales in same month on last year (Date format Month_YYYY)

    Saharat Sakulsaowapakkul

      Hello everyone

       

      I have 3 dimension which is [Department] stacking with [Sub-Department] with MONTH[Date] (January 2017) and 1 measure [Sales]

       

      I would like to create another measure call [Last Year Sales] which would show sales of current month on last year.

       

      Please kindly noted that the format of Date in this requirement is fix and cannot be adjusted into other option (MONTH NAME_YYYY)