Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Simple current year function but returns a blank column Help please

current year sales =
CALCULATE(sum(SalesDashboard[Sales_Amount_Actual]),('date'[Date])=year(today()))
 
Returns a blank column no sure what I am missing.
 
Thanks in advance
Jamie
Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    you are comparing Date with Year number. try

    CALCULATE(sum(SalesDashboard[Sales_Amount_Actual]), YEAR('date'[Date])=year(today()) )

    also make sure your Date field has a Date data type

3 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    you are comparing Date with Year number. try

    CALCULATE(sum(SalesDashboard[Sales_Amount_Actual]), YEAR('date'[Date])=year(today()) )

    also make sure your Date field has a Date data type

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      That was it thanks so much for your help

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    6 years ago

    Anonymous 

    ‘date'[date] is a date value which contains year, month and day.

    year(today()) only returns year value 2020.