topic Current year + 2 quarters in dimension in App Development

Current year + 2 quarters in dimension

adurgani — Wed, 24 Jul 2019 15:11:59 GMT

Hello;

I am looking for help in creating an automated calculated dimension that uses today's dates to bring up the current 6 quarters in a dimension:

7/24/2019 - 4 quarters of 2019 and 2 quarters of 2020

I need this in a dimension.

Re: Current year + 2 quarters in dimension

adurgani — Wed, 24 Jul 2019 16:36:45 GMT

I have this and it works but it needs to be automated based on today's date to return current year quarters and next two quarters in next year:

=if(match([Fiscal Quarter],'Q1-2019','Q2-2019'......'Q2-2020'),[Fiscal Quarter])

Re: Current year + 2 quarters in dimension

dplr-rn — Wed, 24 Jul 2019 17:04:14 GMT

Do you have master calendar dimension like quarter year?
if so use that as dimension and use set analysis in your expression
e.g. below for last 6 quarters
Sum({<OrderDate={">=$(=quarterstart(AddMonths(today(),-18))) <=$(=today())"}>}LineSalesAmount)

this will give you data from 1st jan 2018 to today

Re: Current year + 2 quarters in dimension

adurgani — Wed, 24 Jul 2019 17:48:48 GMT

That does work except that I'm trying to limit the quarters in a dimension not as a measure.

Is that possible?

We do have Fiscal Quarter as a calendar item.

Re: Current year + 2 quarters in dimension

dplr-rn — Wed, 24 Jul 2019 17:52:08 GMT

Thats the value of set analysis

if you limit the data being bought in using the measure the dimensions will automatically only show that.

e.g. in my example it will show only those quarters.

you can possibly do this through if statements on dimension etc. but it is not recommended practice as it will reduce performance. Set Analysis is the recommended route

Re: Current year + 2 quarters in dimension

adurgani — Thu, 25 Jul 2019 18:31:46 GMT

Thanks! In this case it was a preference and a learning opportunity.