Calculate First and Last Day of the previous Quarter

[RafaelPassarell]

Hi Guys,

I am not being able to write two DAX measures that bring me these:

Today = 04/25/2019

First Date of the Previous Quarter

eg.: 01/01/2019

FirstDayPreviousQuarter = CALCULATE(DATEADD('Date'[Date],-1,QUARTER)) => Got an error. Is that correct?

Last Date of the Previous Quarter

eg.: 31/03/2019

Tried this

FirstDayCurrentQuarter = STARTOFQUARTER('Date'[Date]) => result 1/1/2016 (why 2016?)

LastDayPreviousQuarter = [FirstDayCurrentQuarter]-1 => Works, but as the above is not OKAY, this is subtracting 1 from a not okay date. Is there a better way to subtract 1 day from a date?

Thank you!

[parry2k · Accepted solution]

@RafaelPassarell seems like you have date dimension in  your model.

You can do something like this and add following for last date of prev quarter by changing MIN to MAX

First Date of PQ = 
VAR myDate = TODAY()
RETURN
CALCULATE( MIN( 'Date'[Date] ), PREVIOUSQUARTER( CALCULATETABLE(VALUES( 'Date'[Date]), 'Date'[Date] = myDate) ) )

[RafaelPassarell]

Perfect!!

Thank you @parry2k 

FirstDayPreviousQuarter =

VAR myDate = TODAY()

RETURN

CALCULATE( MIN( 'Date'[Date] ), PREVIOUSQUARTER( CALCULATETABLE(VALUES( 'Date'[Date]), 'Date'[Date] = myDate) ) )

LastDayPreviousQuarter =

VAR myDate = TODAY()

RETURN

CALCULATE( MAX( 'Date'[Date] ), PREVIOUSQUARTER( CALCULATETABLE(VALUES( 'Date'[Date]), 'Date'[Date] = myDate) ) )