这是我的DAX函数,它给出了我本月的总金额(比如销售额(:
Current Month =
CALCULATE(
SUM (Budget[Amount]),
FILTER(
ALL ('Calendar'),
'Calendar'[MonthDate]= DATE(YEAR(TODAY()), MONTH (TODAY()),1)
)
)
我怎样才能编辑它,给我上个月的金额,这样我就可以比较一个月比一个月?
你可以试试这个
Previous Month = CALCULATE (SUM (Budget[Amount]),
FILTER (ALL ('Calendar'),
'Calendar'[MonthDate]= DATE (YEAR ( TODAY ()), MONTH (TODAY () ) , -1 )))
要将当月销售额与上月进行比较,可以将当月存储在如下变量中:
Last_Month_Sales=var Current_Month=Month(TODAY(((return CALCULATE(SUM(Budget[Amount](,FILTER(ALL('Calendar'(,"日历"[MonthDate]=当前_月-1((