Medida para Promedio Diario Mensual (Mes en Curso y Mes Anterior Cerrado)

[gus_jr]

Buenos días, para todos. Estoy trabado, en un calculo de un promedio diario de cada mes de toneladas.

Trabajo con tres tiendas que trabajan una de Lunes a Viernes, otra de Lunes a Sábados y otra de Lunes a Domingos.

Armé 3 medidas para "días laborales" de cada mes

Abril:

Lunes a Viernes 22 días

Lunes a Sábados 26 días

Lunes a Domingos 30 días

y 3 medidas para "días transcurridos hasta hoy"

Abril:

LaV 20 dias

LaS 23 dias

LaD 26 dias

Quiero armar un promedio diario mensual, en el que divida por "dias laborales" los meses ya finalizados y que divida por "dias transcurridos" el mes en curso aun no finalizado. Espero haya sido claro.

Agrego una imagen

[v-tangjie-msft]

Hi @gus_jr ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? Such as your desensitized example data and a screenshot of your desired results?

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Neeko Tang

[gus_jr]

Ok, thanks for the suggestion! I share the table in Excel, of the calculation sought. Mainly, I need the sales to be divided by the days elapsed. Of course, in the case of the current month (not yet completed), divide the sales by the days until today (or yesterday).

Today is 04/15/2024
	sales $	Business Days (Monday to Friday)	Business Days Elapsed	Projection (Searched Calculation)	Result
January	1.500,00	23	23	1.500,00	1.500,00
February	2.200,00	21	21	2.200,00	2.200,00
March	1.900,00	21	21	1.900,00	1.900,00
April	2.500,00	22	11	5.000,00	5.000,00
May	3.100,00	23	0	0	0
June	4.500,00	20	0	0	0
July	1.150,00	23	0	0	0
August	2.300,00	22	0	0	0
September	1.850,00	21	0	0	0
October	2.200,00	23	0	0	0
November	2.900,00	21	0	0	0
December	3.000,00	22	0	0	0

[v-tangjie-msft]

Hi @gus_jr ,

(1) This is my test data.  

(2) We can create a  calculated column.

Result = 
var today =TODAY()
var _days_until_today=DATEDIFF(DATE(YEAR(TODAY()),MONTH(TODAY()),1),TODAY(),DAY)
RETURN 
IF([Business Days (Monday to Friday)]=[Business Days Elapsed],DIVIDE([sales],[Business Days Elapsed],0),IF([Business Days Elapsed]<>0,DIVIDE([sales],_days_until_today,0),0))

(3) Then the result is as follows.

According to your description, January through April have passed, so the result is sales divided by the days elapsed. today in May is 5/6, so it's sales divided by 5  (6-1).

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[gus_jr]

Adjunto una imagen para ampliar la situacion.

El error es que en los meses anteriores (Enero, Febrero, Marzo) me divide por lo transcurridos del corriente mes. Alguna idea? Gracias!

[gus_jr]

Me olvidé mencionar que lo me que esta haciendo ahora es dividir por lo dias transcurridos del mes actual todos los meses (actual y anteriores).

Gracias de nuevo!