Calculate sales of product the first 12 months

[Anonymous]

Hi Everyone, 

I am trying to create a measure that calculate the first 12 month of a product sales and when it's more than 12 months, the measure will not calculate the product sales anymore. 

I have two tables sales and dimdate.

I would like to use the launch date to create the measure something that i am not doing right now. 

This is my measure :  

sales =

VAR LaunchMonthNo =

MIN ( 'dimdate'[MonthOverYears] )

VAR TargetMonthNo = LaunchMonthNo + 11

RETURN

CALCULATE (

SUM ( Sales[Amount] ),

FILTER (

'Sales',

Sales[Date] >= MIN ( NPD[Launch Date] )

&& Sales[Date]

<= MAXX (

FILTER ( ALL ( 'dimdate' ), 'dimdate'[MonthOverYears] = TargetMonthNo ),

'dimdate'[date]

)

)

Thank you in advance

[amitchandak · Accepted solution]

@Anonymous , try something like this

CALCULATE (
SUM ( Sales[Amount] ),
FILTER (
'Sales',
Sales[Date] >= MIN ( NPD[Launch Date] )
&& Sales[Date]
<= eomonth(MAX ( NPD[Launch Date] ),12)
))

or

CALCULATE (
SUM ( Sales[Amount] ),
FILTER (
'Sales',
Sales[Date] >= MIN ( NPD[Launch Date] )
&& Sales[Date]
<= MAX ( NPD[Launch Date] ) +365
))

[Anonymous]

Hi  amitchandak ! 

Thank you so much for the support ! It works like a charm ! 

Regards

Ilhame