cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Simple current year function but returns a blank column Help please

@jnaugle 

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

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Simple current year function but returns a blank column Help please

@jnaugle 

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

View solution in original post

Highlighted
Memorable Member
Memorable Member

Re: Simple current year function but returns a blank column Help please

@jnaugle 

‘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.Appreciate your Kudos!
Proud a to be a Datanaut!
Thanks and BR
Ryan
Highlighted
Regular Visitor

Re: Simple current year function but returns a blank column Help please

That was it thanks so much for your help

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors