How to get previous quarter's previous quarter data?

[Narmadha]

I want dax to get previous quarter' s previous quarter data?

[Anonymous · Accepted solution]

Hi @Narmadha ,

To get the sum of last 2 quarter, you may try:

Last 2 Quarters = CALCULATE(SUM('Table'[Value]),DATEADD('Table'[Date].[Date],-2,QUARTER))

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vijay_A_Verma]

To get previous to previous quarter's data, enclose PREVIOUSQUARTER with another PREVIOUSQUARTER.

Below is an example for a measure

PREVIOUSQUARTER Data:=CALCULATE(SUM(Table3[Amount]),PREVIOUSQUARTER(PREVIOUSQUARTER('Calendar'[Date])))

[cn4422]

Thx, that really works, haha, awesome! 😍