cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcabeza
Frequent Visitor

Create a column that contains the previous average of days

I have 2 tables.
The First with the calendar of the year (Calendario)
The Second with daily assistance. (Asistencia)
As shown below

                 Calendario.jpg           Asistencia.png

 

 

I need to add a column to the attendance table that shows the previous average of the last 3 weeks (excluding the day) according to the day as for example

 

Resultado Esperado.jpg

 

I did this Dax formula but only the attendance of the day and I do not know how to add the filter per day

 

Prom Anterior Diario = CALCULATE(AVERAGEX(Asistencia;Asistencia[Asistencia]);DATESBETWEEN(Calendario[Fecha];DATEADD(Asistencia[Fecha];-21;DAY);DATEADD(ResumenDiario[Fecha];-1;DAY))

3 REPLIES 3
Highlighted
affan Solution Sage
Solution Sage

Re: Create a column that contains the previous average of days

Hi @jcabeza,

 

Please use the below DAX

Prom sAnterior Diario = CALCULATE(AVERAGEX(Asistencia,Asistencia[Asistencia]),DATESBETWEEN(Calendario[Fecha],DATEADD(Asistencia[Fecha],-21,DAY),DATEADD(Asistencia[Fecha],-1,DAY)))

I have got the below result from this DAX

Asistencia.png

 

 

 

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

jcabeza
Frequent Visitor

Re: Create a column that contains the previous average of days

It's not the solution, but thanks

affan Solution Sage
Solution Sage

Re: Create a column that contains the previous average of days

Hi @jcabeza

 

Can you please share what issue you got with this measure? What result does this show in your data?

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors