Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Date filter for month and year

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)))
1 ACCEPTED SOLUTION
themistoklis
Community Champion
Community Champion

OR 

@Anonymous

 

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

View solution in original post

6 REPLIES 6
themistoklis
Community Champion
Community Champion

OR 

@Anonymous

 

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

here is some sample data....

 

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

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")

@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
Not applicable

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

try this

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

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")

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors