12 months prior rolling year

[brinky]

Hi,

I have cretaed this measure wihich is RYR (ie July 2018 till June 2019)

Any idea how I could get the 12 months prior July 2018 (ie.July 2017 till June 2018)

RYR = 
CALCULATE(
    Grouped[GRP T QTY],
DATESINPERIOD(dDate[Date],
MAX(dDate[Date]),
-1,YEAR
)
)

[Ashish_Mathur]

Hi,

What is Grouped[GRP T QTY]? That looks like a column but the first input to the CALCULATE() function should be a measure. I do not understand.

[brinky]

@Ashish_Mathur GRP T QTY is a sales measure for unit sales 

GRP T QTY = SUM(Grouped[quantity])

[Ashish_Mathur]

Hi,

Try this measure

RYR = CALCULATE([GRP T QTY],DATESYTD(dDate[Date],"30/6"))

RYR Previous = CALCULATE([RYR],SAMEPERIODLASTYEAR(dDate[Date]))

Hope this helps.

[brinky · Accepted solution]

@Ashish_Mathur Your measure didn't work but with some adjustments I manged to get it working. Thanks to your idea I was able to get the correct measure.

RYR = 
CALCULATE(
    Grouped[GRP T QTY],
DATESINPERIOD(dDate[Date],
MAX(dDate[Date]),
-1,YEAR
)
)

12M Prior RYR =CALCULATE(Grouped[RYR],SAMEPERIODLASTYEAR(dDate[Date]))

[Ashish_Mathur]

You are welcome.

[parry2k]

@brinkyhow about changing -1 to -2

[brinky]

@parry2k Thanks for your reply, did get a value, but defiently not a correct one.

[parry2k]

@brinky if your -1 is giving the correct data I expect -2 will also give the correct data. May be you want to check your last year data as well.

Although if you can share sample pbix, it will help you to get the solution,

[brinky]

@parry2k Maybe this could help as unfortunately I cannot share, ammount should be in region of 151,174 in measure3 (where I did -2)