TOTALQTD but starting one month later (Feb instead of Jan)

[Anonymous]

Hello,

I hope that you cna help me with this, should be an easy fix but i am stuck. I have the following formula to calculate a certain sum of points until the begining of every quarter:

Period since award = TOTALQTD([SUM of Points];vMASTERCalendarLast12Month[Date])

What I need is the same calculation but also that the Quarter starts one month later - instead of Jan in Feb, instead of Apr in May (visualisation below I have TOP P and I need also TOP I)..


Thanks a lot in advance.

Cheers.

[parry2k]

@Anonymous try this measure

Period since award Move 1 Month = 
CALCULATE(
[SUM of Points];
DATEADD(
DATESQTD(vMASTERCalendarLast12Month[Date]),
1,
MONTH
) 
)

[Anonymous]

Thanks a lot for the quick answer @parry2k  , unfortunatelly it seems that the formula doesn´t add the points correctly and i have no filters set. I also tried to add the same date filter to my original formula but didin´t work.

[parry2k]

@Anonymous I have tested it at my end and it works fine. do you have calender dimension in your model?

[Anonymous]

@parry2k  Hi, first thank again for the fast response. I am not sure what exactly you mean but my Data structure for date is the following:

But then again i am not using any date formating or filter in the representation of the data: