New table with sums dependent on month not working

[Anonymous]

Hi, I have data with
* Customer ID

* Item ID

* Month

* Sales

In the months from July through December

I want to create a new table with 
* Customer ID

* Item ID

* Sum of sales from July to November

* Sales from December

Customer/Item Sales =
SUMMARIZE (
    Append1,
    Append1[Customer ID],
    Append1[Item ID],
    "July-November Sales", CALCULATE ( SUM ( Append1[Sales] ), Append1[Month] < MONTH ( 12 ) ),
    "December Sales", CALCULATE ( SUM ( Append1[Sales] ), Append1[Month] = MONTH ( 12 ) )
)

This code returns Customer ID and Item ID, but the other two columns I wanted to create show as blanks. What am I doing wrong?

Thanks

[parry2k · Accepted solution]

Not sure why you have month (12), I believe you already have month field with month number in it.

Customer/Item Sales =
SUMMARIZE (
    Append1,
    Append1[Customer ID],
    Append1[Item ID],
    "July-November Sales", CALCULATE ( SUM ( Append1[Sales] ), Append1[Month] <  12  ),
    "December Sales", CALCULATE ( SUM ( Append1[Sales] ), Append1[Month] =  12  )
)

[Anonymous]

@parry2k

Had to go back to edit queries to make the month an actual number. But then your code worked. Thanks

[parry2k]

Glad to hear 🙂