Beginning of the year + 3 months DAX Calculation

[mpmsltd]

Hi All,

I'm trying to create a DAX formula that for each year does a sum of my values from day 1 until day 90 of the same year. 

I tried to use the DAX below but it didn't really work, I've got the following error:

a table of multiple values was supplied where a single value was expected

Year + 3 Months IT = CALCULATE(sum(Values[values]),DATESBETWEEN('DATE'[Date],STARTOFYEAR('DATE'[Date]),DATEADD('DATE'[Date],3,MONTH)))

Any help is appreciated,

thanks!

[Greg_Deckler]

Perhaps:

Year + 3 Months IT = 
VAR __YearStart = DATE(YEAR('Values'[Date]),1,1)
VAR __End = (__YearStart + 89) * 1.
RETURN
  SUMX(
    FILTER(
      'Values',
      [Date] >= __YearStart && [Date] <= __End
    ),
    'Values'[Value]
  )

[mpmsltd]

Your solution was a great help, really appreciated it!

[mpmsltd · Accepted solution]

Thanks Greg, I've tweaked a little bit since the Year function wouldn't let me add a column but only another function.

This is what I did and it worked 

Year + 3 Months IT =

VAR __YearStart = STARTOFYEAR('DATE'[Date])

VAR __End = (__YearStart + 89) * 1.

RETURN

SUMX(

FILTER(

Valued,

Values[Date] >= __YearStart && Values[Date]<= __End

),

Values[Value]

)