12 month sum indicator

[Marcin]

Hi,

let assume we have data like this :

Date	Sales
01.01.2017	-30
01.02.2017	94
01.03.2017	63
01.04.2017	90
01.05.2017	50
01.06.2017	-14
01.07.2017	46
01.08.2017	-51
01.09.2017	-76
01.10.2017	65
01.11.2017	-14
01.12.2017	-65
01.01.2018	53
01.02.2018	-34
01.03.2018	86
01.04.2018	-51
01.05.2018	26
01.06.2018	-25
01.07.2018	85
01.08.2018	-24
01.09.2018	71
01.10.2018	-10
01.11.2018	10
01.12.2018	-70

I would like to create measure that will be working as 12 months sum but only in 12 months period of time : time <= maxdate, time >= maxdate - 12.

I have created a measue like this :

Last 12 months = CALCULATE(SUM(Table1[Sales]),DATESINPERIOD(Table1[Date],LASTDATE(Table1[Date]),-12,MONTH))

But now I would like to adjust it to get only last 12 month values but sum to be caluculated also as a total of months before last 12 month. 

I would like to get a view like this ( alwyays for last 12 months )  and count how many of values per month was negative. 

 

[Greg_Deckler · Accepted solution]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...