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

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

Anonymous 

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

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