Hi All,
To start off, my sql and DAX skills are not advanced.
I am working with data from the fulfilment area of a bank.
Thousands of applications come in daily and the database is saving the history of each move as the work item moves through queues.
We are calculating the man power needed to work each queue per day and per month.
The way I have worked out the daily resources needed is by assigning each queue a Resources Required figure.
To work out the daily resources required, I sum the Resources Required figure per queue to give me the total needed per day.
This works perfectly for a daily view.
I can clearly see the theoretical amount of resources needed per day.
Now, when I drill up to monthly, I can only see the sum of all of the days in the month which gives a figure which is far too large.
For example (pretending only 3 days in a month): Day 1- 20 people needed, Day 2 - 30 people needed, Day 3 - 25 people needed.
When I drill up to monthly and sum is selected, the total is 75 which is far too large.
And when I select max it will give me an extremely small figure such as 0.02 (largest of the small figures used to get the sum of 20, 30 or 25 as in the example above).
My goal is to display the max of the daily summed values in the monthly view.
So with regards to the "example" above, I would like the Day 2 figure of 30 to display as the max for the month - the largest summed daily value shoudl reflect as the max on the monthly view.
Please assist and try keep your answers as basic as possible 🙂
Read many other threads and they're a bit too advanced for me.
Thanks!
