Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |