Solved: Simple current year function but returns a blank c...

jnaugle · ‎06-01-2020

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

az38 · ‎06-01-2020

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

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

ryan_mayu · ‎06-01-2020

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

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

az38 · ‎06-01-2020

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

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

jnaugle · ‎06-01-2020

That was it thanks so much for your help

Simple current year function but returns a blank column Help please