topic Re: DYNAMIC QUARTER MOVIL in DAX Commands and Tips

DYNAMIC QUARTER MOVIL

Anonymous — Fri, 24 Apr 2020 02:09:20 GMT

Hi everybody

I want to create a measure that give me QUARTERL SALES, for example:

SALES1 = JAN, FEB, MAR (IN MARCH)

SALES2 = FEB, MAR, APR (IN APRIL)

SALES3 = MAR, APR, MAY (IN MAY)

SALES4 = APR, MAY, JUN (IN JUNE)

SALES 5 = MAY, JUN, JUL (IN JULY)

I tried this:

VAR Date1= Max(Calendar[Date])

VAR Date2 = Date1 - 1

VAR Date3 = Date1 - 2

RETURN CALCULATE([Sales];Calendar[Date]=Date1) + CALCULATE([Sales];Calendar[Date]=Date2) + CALCULATE([Sales];Calendar[Date]=Date3)

But I did not make it. I was learning using DAX

Re: DYNAMIC QUARTER MOVIL

vivran22 — Fri, 24 Apr 2020 02:55:47 GMT

Hello Anonymous ,

Try this:

Qtr Sum2 = VAR _StartMonth = MAX(Calendar[Date]) VAR _QtrSum = CALCULATE( [Sales], DATESINPERIOD(Calendar[Date],_StartMonth,-3,MONTH) ) RETURN _QtrSum

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

Re: DYNAMIC QUARTER MOVIL

Anonymous — Fri, 24 Apr 2020 03:57:59 GMT

The measure works very well!! Eres un crack !!!

Share the result:

EQC Promotores 3MM =

VAR _StarMonth = MAX('BD Calidad Venta'[FECHA])

VAR _QtrSum = CALCULATE(

[EQC Promotores Acum.];

DATESINPERIOD('BD Calidad Venta'[FECHA];_StarMonth;-3;MONTH)

)

RETURN

_QtrSum

Thanksss !!