Date filter for month and year

[Anonymous]

Hi Experts

Cannot see my error on the following DAX...

i want to filter my sales for the year 2017 and month Feb only

Symbias Feb 17 = CALCULATE([Symbias, Inc organic Dynamic Measure],
        FILTER(ALLSELECTED(DateFilter),
                DATEDIFF([Year Nbr]=2017,DateFilter[Month Short Name]=Feb)))

[themistoklis · Accepted solution]

OR 

@Anonymous

Symbias Feb 17 = CALCULATE(SUM([Symbias, Inc organic Dynamic Measure]), [Year Nbr] = 2017, [Month Short Name] = "Feb")

[Anonymous]

here is some sample data....

I am need to the following numbers... see image...

here is my formula.....still cannot get it to work

Symbias Organic = CALCULATE(
        [Net Sales BM],
        FILTER(ALL('DateFilter'),[Year Nbr]=2017),DateFilter[Month Short Name]="FEB")

[themistoklis]

@Anonymous

You have accepted a solution so i dont know if you are happy with it, or you still have issues with the formula.

Now regarding the last message, the formulas is not correct. It should look like the following formula:

Symbias Organic = CALCULATE(
        SUM([Net Sales BM]),
        DateFilter[Year Nbr]=2017),
        DateFilter[Month Short Name]="FEB"
)

[Anonymous]

All Experts

I worked out the same formula that has just been posted. So i expected the solution which gave me the direction..as to how to work out the solution.

Thanks all for the excellent feedback

[Nastasita]

try this

Symbias Organic = CALCULATE(
        [Net Sales BM],
        FILTER(ALL('DateFilter'),[Year Nbr]=2017,DateFilter[Month Short Name]="FEB"))

[Nastasita]

you do not need to use DateDiff function and Filter expression should be rewriting in such way

FILTER(ALL('TableName'),[Year Nbr]=2017,[Month Short Name]="Feb")