Forum Discussion
DAX Statement for current year only
I have dashboard built off underlying excel spreadsheets which have ytd expenditures and forecasted expenditures future month expenditures. I have pulled this into a table that also includes 2018 ac...
Anonymous
There are many ways to specify the current year. One way is to use the values of your date dimension table in the year colume with a measure like:
DimDate[Year]) = YEAR(TODAY())
You can also use the DAX for Start of Year:
STARTOFYEAR(<dates>)
and End of Year:
ENDOFYEAR(<dates> [,<year_end_date>])
Use these in your formula to calculate the appropriate start and end points to create a dynamic calculation.
Resources: