Rolling monthly moving annual count

[the606]

Hi,

Im trying to create a bar chart visual giving me a count of all projects in the previous year from the month shown in the graph.

So using year in the Axis and the month in the Legend.

I have created the following but obvisouly it gives me the same figure as i have specified today, i cant seem to get what i need no matter what i do!

Moving Annual From Today = CALCULATE([Order Count], DATESINPERIOD('Date'[Date], TODAY(), -12, month))

Order Count = COUNT('Project Master'[Project Number])

So to be clear.

The first bar in the chart would show an order count from previous 12 months from today, the second bar would show an order count from a month ago to the previous 12 months and so on.

Im pulling my hair out.

[amitchandak · Accepted solution]

@the606 , You are trying to plot against time so it should change every month

Moving Annual = CALCULATE([Order Count], DATESINPERIOD('Date'[Date], max(Order[Date]), -12, month))

or

Moving Annual = CALCULATE([Order Count], DATESINPERIOD('Date'[Date], max(Date[Date]), -12, month))

[the606]

Wonderful! thanks so much, i was really struggling with this.