表示範囲内での累計
DAX
MTD_amount =
CALCULATE(
SUM('daily_sales_summary'[amount]),
FILTER(
ALLSELECTED('daily_sales_summary'),
ISONORAFTER('daily_sales_summary'[date], MAX('daily_sales_summary'[date]), DESC)
)
)
365日移動平均(※当日は含めない)
DAX
ma_amount =
VAR interval = -365
RETURN
CALCULATE(
SUMX('daily_sales_summary', 'daily_sales_summary'[amount]) / DISTINCTCOUNT('daily_sales_summary'[amount]),
DATESINPERIOD(
'daily_sales_summary'[amount],
LASTDATE('daily_sales_summary'[amount])-1,
interval,
DAY
)
)
※含める場合は-1を削除