Power BI DAX-moving average

 Power BI community-Moving-Average/td-p/43041
時間智慧函式

Date 與 Time 函式

DATESINPERIOD 函式(DAX) - DAX | Microsoft Docs

傳回包含日期資料行的資料表，以特定開始日期開始並繼續經過指定的日期間隔和類型

DATESINPERIOD(<dates>, <start_date>, <number_of_intervals>, <interval>)

如果指定給 number_of_intervals 的數字是正數，則日期時間會向前移；如果數字是負數，則日期時間會向後退

interval 參數是列舉類型。 有效值為 DAY、MONTH``QUARTER 及 YEAR。 由於其是列舉類型，所以不會以字串傳入值。 因此不要將其括在引號內。

Revenue PY =
CALCULATE(
SUM(Sales[Sales Amount]), DATESINPERIOD( 'Date'[Date], MAX('Date'[Date]), -1,
YEAR
) 
)
DATESINPERIOD - DAX函数大全- Power BI极客
Total Sales rolling quarter :=
CALCULATE (
Sum(data[qty]),
FILTER (
ALL ( Calendar ),
Calendar[MonthID] >= MAX (calendar[MonthID]) -2
&& Calendar[MonthID] <= MAX ( Calendar[MonthID] )
)
)
EOMONTH(TODAY(),-1)代表今天的日期向前推移一個月的月末日期
原文網址：https://kknews.cc/code/vl89lvq.html
Create a calculated column for the date
FullDate =
DATE ( 2016, 'Session'[Month of the Year], 1 )

1. Create a measure for 3 months moving average. You can change the number of months if you want.

Moving_Average_3_Months =
CALCULATE (
AVERAGEX ( 'Session', 'Session'[Sessions] ),
DATESINPERIOD (
'Session'[FullDate],
LASTDATE ( 'Session'[FullDate] ),
-3,
MONTH
)
)

1. Drag the Line Chart into your canvas as below.
2.