cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## get last period of PREVIOUS quarter

Hello

I build the bellow calculation to get last period of current quarter:
CALCULATE (
SUM(_COFI[volume]),
_COFI[level2] = "Assets",
ENDOFQUARTER(_COFI[PERIOD])
)

Now I am trying to get : last period of the previous quarter
I am still able to get last period (with "endofquarter") but always from current quarter and not previous quarter.
Here is one of the example I tried with DATESINPERIOD :
CALCULATE (
SUM(_COFI[volume]),
_COFI[level2] = "Assets",
ENDOFQUARTER(DATESINPERIOD(_COFI[PERIOD], MAX(_COFI[PERIOD]), -1, QUARTER)
))

All my data are within 1 single table, as bellow:

If someone have jus an indea how I should process, it would already help a lot.

Thanks !

Super User

@Anonymous54000 , with help from date table

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

Qtr Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(ENDOFQUARTER('Date'[Date])))

Last QUARTER Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD( ENDOFQUARTER(dateadd('Date'[Date],-1,QUARTER))))
Last QUARTER Sales = CALCULATE(SUM(Sales[Sales Amount]),PREVIOUSQUARTER(('Date'[Date])))

for last period of qtr use this measure in place sum of sales

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

QTD Sales = CALCULATE([MTD Sales],DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE([MTD Sales],DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

Qtr Sales = CALCULATE([MTD Sales],DATESQTD(ENDOFQUARTER('Date'[Date])))

Last QUARTER Sales = CALCULATE([MTD Sales],DATESQTD( ENDOFQUARTER(dateadd('Date'[Date],-1,QUARTER))))
Last QUARTER Sales = CALCULATE([MTD Sales],PREVIOUSQUARTER(('Date'[Date])))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors