Forum Discussion

brinky's avatar
brinky
Icon for Helper IV rankHelper IV
7 years ago
Solved

12 months prior rolling year

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[GR...
Need Help
  • brinky's avatar
    brinky
    7 years ago

    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's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

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's avatar
brinky
Icon for Helper IV rankHelper IV
7 years ago

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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    You are welcome.