Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost 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('Date'[Date],-3,MONTH))+
CALCULATE([BP],PARALLELPERIOD('Date'[Date],-2,MONTH))+
CALCULATE([BP],PARALLELPERIOD('Date'[Date],-1,MONTH))+
CALCULATE([BP],PARALLELPERIOD('Date'[Date],-0,MONTH)))

 

 

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!

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity 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!