Trying to create a measure for the Sales Contribution for just January

[gbarr12345]

Hi everyone,

I'm trying to create a measure that shows the Sales Contribution for just the month of Janaury but it's returning all months and not just January as per the screenshot below.

Can anybody spot where I'm going wrong with my measure? Please see it below.

The year is 2015 as that's what the sample data set provided.

Many Thanks in advance.

Sales Contribution January =

VAR StartDate = DATE(2015, 1, 1)

VAR EndDate = DATE(2015, 1, 30)

RETURN

CALCULATE(

    [Total Sales],

    FILTER(

        DateTable,

        DateTable[Date] >= StartDate &&

        DateTable[Date] <= EndDate &&

        DateTable[Date] >= DATE(2015, 1, 1)

    ),

    ALLEXCEPT(Orders, Orders[Customer Name])

)

[vicky_]

There's two easy options - first is to create a new column in your Date table for the month and put that in the slicer. The other would be to add a line to the filter statement for the month. something like:

    FILTER(
        DateTable,
        ...
        MONTH(DateTable[Date]) = 1
    ),

[gbarr12345]

Thank you for the response and your help 🙂