Calculate Current Full Quarter SALES and Previous Full Quarter SALES in DAX

[Anonymous]

I am trying to calculate the equivalent of the below for Quarter data.  The below provides me the calculation for Month data.

I cannot reconfigure these measures to do the same for Quarter data.  I am wanting Current Full Qrt SALES and Previous Full QRT SALES.  I do have a column in Datetbl of:

QuarterStart = STARTOFQUARTER(DateTbl[Date])

Any help would be greatly appreciated.

tks/

Current Full month SALES =

CALCULATE ([GL Total],

FILTER (

ALL ('DateTbl'),

'DateTbl'[MonthStart]= DATE (YEAR ( TODAY ()), MONTH (TODAY () ) -1, 1 )))

Past Full month SALES =

CALCULATE ([GL Total],

FILTER (

ALL ('DateTbl'),

'DateTbl'[MonthStart]= DATE (YEAR ( TODAY ()), MONTH (TODAY () ) -2, 1 )))

[CNENFRNL · Accepted solution]

Follow such patterns to extract current and previous quarter,

=
VAR __qtr = CALCULATETABLE(DATESQTD(DateTbl[Date]), ENDOFQUARTER(DateTbl[Date]))
RETURN
...

=
VAR __prev_qtr = CALCULATETABLE(DATESQTD(DateTbl[Date]), STARTOFQUARTER(DateTbl[Date])-1)
RETURN
...

[Anonymous]

Thanks so much!

[Anonymous]

Thanks, I have tried using that function and no luck.  Appreciate your post.

[Jihwan_Kim]

Hi,

I think, one of many ways to solve your problem is to use the below DAX function.

PARALLELPERIOD 

https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax