Average from last 3 Months

KVPro — Fri, 19 Nov 2021 10:10:10 GMT

Hello

I want to calculate average from last 3 months for some products

My data looks like:

I have different products A and B with different amount of rows. My last 3M are from 202109 to 202111. For the max value from Year&Month I want to get average from last 3 dates(202109-202111) and I dont want to get average for other dates (0).

How to do it?

I have tried to do as this formula, but it shows 202111 for A - 13655, for B - 6862.

AVG 3M =

CALCULATE(

AVERAGEX('Fact','Fact'[Value]),

DATESINPERIOD('Fact'[Date],MAX('Fact'[Date]),-3,MONTH)

)

Re: Average from last 3 Months

amitchandak — Fri, 19 Nov 2021 11:21:01 GMT

KVPro , With Date Table and Value Meausre

AVG 3M =
CALCULATE(
AVERAGEX(Value('DATE'[Month Year]),[Value]),
DATESINPERIOD('DATE'[Date],MAX('DATE'[Date]),-3,MONTH)
)

topic Re: Average from last 3 Months in DAX Commands and Tips

Average from last 3 Months

Re: Average from last 3 Months