Start and end of previous Quarter

[Anonymous]

hello

please someone knows how to calculate the start or end of previous quarter? 

[Anonymous]

Thank you both for your answer you saved my day =D thank you 

[Fowmy · Accepted solution]

@Anonymous 

If you are creating a new column then

End of PQ = EOMONTH( ENDOFQUARTER( financials[Date] ) , -3 )

Start of PQ = EOMONTH( ENDOFQUARTER( financials[Date] ) , -6 )+1

[nvprasad]

Hi rayloubai,

You can get by using below dax

PrevQtrSTart = EOMONTH(STARTOFQUARTER('Date'[Date]),-4)+1

PrevQtrLast= EOMONTH(STARTOFQUARTER('Date'[Date]),-3)

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[Anonymous]

hello @nvprasad 
thank for your answer, but getting something weird, it displaying 2018 
do you know how i can modify the script to have the normal year like the current one? 🙂