3 Replies Latest reply: Dec 30, 2015 3:22 PM by Sunny Talwar RSS

    Get Quarter in a measure from month selection

    Sujan Janardhan

      Hi ,

       

      I have my data coming in at month(Ex:Apr-15) and i have a date table with month,quarter and year.I am trying to get a measure at quarter level but it has to be dynamic based on a month selected by the end user.For example user would select Apr-15 and the measure should calculate the amount of Q2-15.

       

      My measure for month is Sum({<scenario ={'ACTBUD'})>} amount),simple as month is a selected value,how do i get the quarter value based on the month selection.

       

      Thanks.