Cards with Sum of sales last quarter and last quarter same period

Anonymous — Wed, 08 Feb 2023 05:17:58 GMT

Hi,

I need a card with Sales this quarter, one with Sales Previous Quarter and one with the previous Quarter same period (e.g. if this quarter started 35 days ago, I want the sales of the previous quarter past 35 days and not beyond.

This code seems to work, but I want to make sure it does not create any problem.

Firstly I added a column in the calendar table to have for each date the days past after the beginning of the quarter (see picture).

This quarter Sales =

CALCULATE(SUM('Dataset'[Sales]),'Date'[Quarter number]= QUARTER(TODAY()), 'Date'[Year]= YEAR(TODAY()))

Last Quarter Sales =

var current_date = DATE(YEAR(TODAY()), MONTH(TODAY())-3, DAY(TODAY()))

return

CALCULATE(SUM('Dataset'[Sales]),

'Date'[Quarter number]= QUARTER(current_date), 'Date'[Year]=YEAR(current_date))

Last Quarter Same Period Sales =

var current_date = DATE(YEAR(TODAY()), MONTH(TODAY())-3, DAY(TODAY()))

var Days_Past = CALCULATE(SUM('Date'[Days Past (Quarter)]), 'Date'[Date] = TODAY())

return

CALCULATE(SUM('Dataset'[Sales]),

'Date'[Quarter number]= QUARTER(current_date),

'Date'[Year]=YEAR(current_date),

'Date'[Days Past (Quarter)]<= Days_Past

)

topic Cards with Sum of sales last quarter and last quarter same period in DAX Commands and Tips

Cards with Sum of sales last quarter and last quarter same period