Average volume for the last 24 months

[Sammy22]

Hello,

i need to calculate the average volume for a customer using the last 24 months. I tried to use a filter on the date but i will need to change this each month. My data looks like the below. How can i do this?

Order Id	Customer	Volume	Date
2.32E+04	a	3	2/18/2019
32e23e	a	4	2/18/2019
e2e3	a	3	2/18/2019
e2e2	a	7	3/29/2019
23ed2ed	a	4	3/29/2019
23ed23	a	3	5/2/2019
32ed23	b	22	5/2/2019
23ed2d	b	3	5/2/2019
2.30E+03	b	4	5/2/2019
1231ew	b	3	5/3/2019

[PhilipMannering · Accepted solution]

Hi Sammy,

I think you're trying to filter your data dynamically. You could do this with,

datetimediff(datetimetoday(), datetimeparse([Date], '%m/%d/%Y'), 'mon') < 24