Moving Annual Order count for previous 12 months

[the606]

Hi,

Im new to this and I have managed to create all of the measures so far but I am stuck.

I need to create a measure to count the previous 12 months orders, I have a column Sales Master 'Order number' and I wish to count this to show a rolling twelve months (based on a finish date of TODAY) of the previous 12 months orders.

Can you give me some help please?

Stay Safe!

[mahoneypat]

Please give this a try-

NewMeasure = CALCULATE([Order Count], DATESINPERIOD('Date'[Date], TODAY(), -12, month))

This assumes you have a Date table and a measure called Order Count.

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[the606]

Thanks very much, im not using a separate date table, can i link this with the order date instead?

[the606]

I created a date table and this calculation works perfectly!

However it has shown me that i am not asking the right question.

Im trying to create a graph that shows a count of what the previous 12 months orders are at that time. this way we can see what the rolling moving annual is in that month and show whether the trend is increasing. I want to have the months on the legend and the years as the axis. I hope this makes sense its not easy to explain (for me anyway).