Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago
Solved

Minimize measure

There are anyways to minimize this measure?   CALCULATE(CALCULATE([BP],PARALLELPERIOD('Date'[Date],-5,MONTH))+ CALCULATE([BP],PARALLELPERIOD('Date'[Date],-4,MONTH))+ CALCULATE([BP],PARALLELPERIOD...
Need Help
Show and Tell
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Analitika ,

    Try the measure as below:

    var _Sum=CALCULATE([BP],FILTER(ALL('Date'),MONTH('Date'[Date])<=MONTH(MAX('Date'[Date]))-5&&YEAR('Date'[Date])=YEAR((MAX('Date'[Date])))
Return
If(MONTH('Date'[Date])<5,_Sum+CALCULATE([BP],FILTER(ALL('Date'),MONTH('Date'[Date])>=12-MONTH(MAX('Date'[Date]))+1&&YEAR('Date'[Date])=YEAR((MAX('Date'[Date]))-1,_Sum

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

amitchandak's avatar
amitchandak
Super User
5 years ago

Analitika , Try like

Rolling 5 = CALCULATE([BP],DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-5,MONTH))

or

Rolling 5 = CALCULATE([BP],DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-5,MONTH))

 

you might have to use 6 in place of 5

  • Analitika's avatar
    Analitika
    Post Prodigy
    5 years ago

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi Analitika ,

      Try the measure as below:

      var _Sum=CALCULATE([BP],FILTER(ALL('Date'),MONTH('Date'[Date])<=MONTH(MAX('Date'[Date]))-5&&YEAR('Date'[Date])=YEAR((MAX('Date'[Date])))
Return
If(MONTH('Date'[Date])<5,_Sum+CALCULATE([BP],FILTER(ALL('Date'),MONTH('Date'[Date])>=12-MONTH(MAX('Date'[Date]))+1&&YEAR('Date'[Date])=YEAR((MAX('Date'[Date]))-1,_Sum

       

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!