Forum Discussion

584100's avatar
584100
New Member
6 years ago
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...
  • az38's avatar
    az38
    6 years ago

    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

      

Anonymous's avatar
Anonymous
Not applicable
6 years ago

CALCULATE(SUMX(sales,salesamount),salesdate="2014")