cancel
Showing results for
Did you mean:
Regular Visitor

Daily production average per month

Hi Community, Need your help to determine the daily production average given a total amount of units to be produced on a daily (workday) basis. I cant find and correct dax for this measurement.

What I'm looking for is having a total number of units to produc in a range on months example: June thru Sept. determining the workdays, how much is that per day for the period.

Reall hope I can get some assistance.

Thank you,

Regards,

Pedro

1 ACCEPTED SOLUTION
Community Support

Hi @ptapia

You can refer to the following example.

Sample data

1.You can create a column to create the weekday

``Weekday = WEEKDAY([Date],2)``

2.Then create a column to create the daily average sales.

``Daily_average = AVERAGEX(FILTER('Table',[Weekday] in {6,7}=FALSE()),[Sales]) ``

Output

The following link describes the function: AVERAGEX()

Best Regards!

Yolo Zhu

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

Community Support

Hi @ptapia

You can refer to the following example.

Sample data

1.You can create a column to create the weekday

``Weekday = WEEKDAY([Date],2)``

2.Then create a column to create the daily average sales.

``Daily_average = AVERAGEX(FILTER('Table',[Weekday] in {6,7}=FALSE()),[Sales]) ``

Output

The following link describes the function: AVERAGEX()

Best Regards!

Yolo Zhu

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