Forum Discussion
Solved
SUMX using Year Function
Amount = SUMX (FILTER(Sales,(YEAR(Sales[Date]=2014))),Sales[Sales Amount])
Above formula is calculating sum of column [Sales Amount] without filtering rows having value only 2014. I just want to have sum of rows for which Year in [Date] column is 2014. Any idea why is it not considering filter condition.
Thanks in advance!!
Chetna
Hi 584100
First, you have an issue with parenthesys YEAR function: YEAR(Sales[Date]=2014) is completely wrong statement
Second, try to use ALL() inside filter
Amount = SUMX (FILTER(ALL(Sales),YEAR(Sales[Date])=2014),Sales[Sales Amount])do not hesitate to give a kudo to useful posts and mark solutions as solution
2 Replies
Hi 584100
First, you have an issue with parenthesys YEAR function: YEAR(Sales[Date]=2014) is completely wrong statement
Second, try to use ALL() inside filter
Amount = SUMX (FILTER(ALL(Sales),YEAR(Sales[Date])=2014),Sales[Sales Amount])do not hesitate to give a kudo to useful posts and mark solutions as solution
