How to compute the Different of ROLL_12_SALES and ROLL_24_SALES ?

[Anonymous]

Hi All

I need to compute the different of below 2 expression :-

ROLL_12_SALES = CALCULATE(sum(SALES[sales]),DATESINPERIOD('Date'[Date],MAX(SALES[date]),-12,MONTH))

ROLL_24_SALES = CALCULATE(SUM(SALES[sales]), DATESINPERIOD('Date'[Date], maxx('Date', DATEADD('Date'[Date],-12,MONTH)),-12, MONTH))

Can some one advise me ?

Paul

[themistoklis · Accepted solution]

@Anonymous 

Have you tried creating a new measure with the following calculation

Measure = [ROLL_24_SALES] - [ROLL_12_SALES]

Or another option is the following:

Difference = 
var _ROLL_12_SALES = CALCULATE(sum(SALES[sales]),DATESINPERIOD('Date'[Date],MAX(SALES[date]),-12,MONTH))
 
var _ROLL_24_SALES = CALCULATE(SUM(SALES[sales]), DATESINPERIOD('Date'[Date], maxx('Date', DATEADD('Date'[Date],-12,MONTH)),-12, MONTH))

Return
_ROLL_24_SALES - _ROLL_12_SALES

[Anonymous]

Hi Themistoklis

Thank you very much for your sharing , it work fine now.

Paul

[aj1973]

@Anonymous 

ROLL_24_SALES     is not correct! you have 2 time intelligence formulas in a same measure!

What do you to do?