current quarter and previous quarter on kpi card

[AresB]

Hi,

im trying to achieve to visualize the current quarter and the previous quarter on a kpi card regarding on the filter i use in the dashboard.

im using this calculation for previous quarter:

PreviousQuarterSales = CALCULATE(SUM(Foglio1[Sales]),DATESQTD(dateadd(Foglio1[Date].[Date],-1,QUARTER)))

 and this work correctly with the filter.

Im looking for something like:

Last QTDes = CALCULATE(SUM(Foglio1[Sales]),PREVIOUSQUARTER(TODAY()))

is there a way to achieve this ?

[WinterMist · Accepted solution]

@AresB 

Please try the following 2 measures for the KPI cards.

Hope this is helpful to you.

Regards,

Nathan

P.S.  I created my own date table in DAX as follows.  The main field used is "Year Quarter Number", highlighted below.  This table was joined to the 'Sales' table on 'Sales'[Order Date].