Forum Discussion
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
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.
1 Reply
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.