Forum Discussion
Monthly Sum
Working towards building a formula, but I believe I need to do this in pieces so I'm not confusing anyone. I've asked this a few times and still haven't found my answer... So I will start simple: ...
Anonymous
Try putting the *12 after the last parenthesis.
Regards
Victor
Lima - Peru
Anonymous Hi, you can use this measure:
LastMonthRevenue =
VAR LastMonthRevenueDate =
MONTH ( LASTDATE ( Table1[Revenue Date] ) )
VAR LastYearRevenueDate =
YEAR ( LASTDATE ( Table1[Revenue Date] ) )
RETURN
CALCULATE (
SUM ( Table1[Revenue] );
FILTER (
Table1;
MONTH ( Table1[Revenue Date] ) = LastMonthRevenueDate
&& YEAR ( Table1[Revenue Date] ) = LastYearRevenueDate
)
)
Regards
Victor
Lima - Peru