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

az38's avatar
az38
Icon for Community Champion rankCommunity 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