Forum Discussion
bvanderwatt
Helper III
Helper IIIRolling Month Sales for completed months
Good Day
I have the below 2 measures. But I want this to be limited to only completed months.
I am struggling to limit it to completed months without using a date slicer. I do use a date table.
Rolling Sales (Foreign) 12M (This Year) =
CALCULATE(
SUM(
'Combined Sales'[Inv+Order_Foreign]),
DATESINPERIOD(
'Calendar'[Date],
MAX(
'Calendar'[Date]
),
-12,
MONTH
)
)
Rolling Sales (Foreign) 12M (Last Year) =
CALCULATE(
[NSls (Foreign) LY],
DATESINPERIOD(
'Calendar'[Date],
MAX(
'Calendar'[Date]
),
-1,
YEAR
)
)
Rather than MAX('Calendar'[Date]) you could use EOMONTH(TODAY(), -1)
1 Reply
johnt75Super User
Rather than MAX('Calendar'[Date]) you could use EOMONTH(TODAY(), -1)