Rolling Six Months

[manu1512]

Hi all,

I have date in format sales date :- 'YYYY-MM'

Now i want to create six months flag..can you please tell me logic.

Kind Regards

Manu

[Sameer9585]

try this?

sum({<Date={$(='>=' & Date(YearStart(addMonths(Date,-5))),'YYYY-MM') & '<=' & Max(Month(Date))}>}sales)

[JordyWegman]

Hi Manu,

Do you mean an indicator that tells you what the last six months are in your calendar?

Then you can do the following:

IF(Date(Addmonths(Today(),-6),'YYYY-MM') >= SalesDate,1,0) as _indRLSM // RollingLastSixMonths

You can use this in set analysis like: Sum({$< _indRLSM = {1}>}Sales)

Jordy

Climber

[manu1512]

Hi Jordy,

Unfortunately i have no calendar in my model,i have only this field in actual table,

will it work there ?? in table

[JordyWegman · Accepted solution]

Hi Manu,

Then you can do this in the set analysis:

Sum({$< Date = {">=$(=AddMonths(Date,-6) <=$(Date)"}>} Sales)

Jordy

Climber