Get Quarter in a measure from month selection

[#1]

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.

[sunny_talwar · Accepted solution]

May be this"

Sum({scenario = {'ACTBUD'}, Quarter = p(Quarter), Month = >} amount)

Where

Quarter = p(Quarter) will include the whole quarter and

Month =  will ignore any selection in Month field

[#3]

Thanks Sunny

[sunny_talwar]

No problem Sujan