How to make my expression display Oct till Dec 2021 sales amount ?

[admin11]

Hi All

I have below expression working fine , it return Sep till Nov 2021 sales :-

QTD Sales Previous = CALCULATE(SUM(Sales[sales]),DATESQTD(dateadd('DATE'[Date],-2,QUARTER)))

May i know how to change the above expression , so that it will return Oct till Dec 2021 sales ?

Paul

[v-yanjiang-msft]

Hi @admin11 ,

The DATESQTD function calculates based on the real quarter, for example, the fourth quarter is from October to December, not quite sure how you would return September to November sales, could you please explain more or provide a sample? It will helpful to solve your problem faster.

Best Regards,
Community Support Team _ kalyj

[themistoklis]

Hello @admin11 ,

Try any of the formulas below:

CALCULATE(SUM(Sales[sales]), DATESBETWEEN('DATE'[Date],DATE(2021,10,01), Date(2021,12,31)))

CALCULATE(SUM(Sales[sales]), FILTER(Sales,  Sales[Date] >= DATE(2021,10,01) && Sales[Date] <= Date(2020,12,31)))

[admin11]

@themistoklis I don't want hard code . As when 3 month later , this expression will auto compute Jan till March sales amount 

[themistoklis]

Hello @admin11 

Please use the following formula

CALCULATE(SUM(Sales[sales]), PREVIOUSQUARTER(Sales[Date]))