Daily production average per month

[ptapia]

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

[v-xinruzhu-msft · Accepted solution]

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()

 AVERAGEX function (DAX) - DAX | Microsoft Learn

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.