Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)))
Solved! Go to Solution.
OR
@Anonymous
Symbias Feb 17 = CALCULATE(SUM([Symbias, Inc organic Dynamic Measure]), [Year Nbr] = 2017, [Month Short Name] = "Feb")
OR
@Anonymous
Symbias Feb 17 = CALCULATE(SUM([Symbias, Inc organic Dynamic Measure]), [Year Nbr] = 2017, [Month Short Name] = "Feb")
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")
@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" )
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"))
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |