Forum Discussion
Hourly Average based on selected days
Hi all I'm having some problems when I try to show the average number of events throughout the day based on number of selected days. I've created 2 measures: - One that sums all my events - On...
Hi AndHan
I don't particularly understand the data you provided .What is the 'Date'[Date] ?
Could you provide a sample that may help us to deal with your issue easier .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
The 'Date'[Date'] is from my Date table - it's used on a date picker in my report.
It returns the number of days selected, so I can use it to calculate the average pr. day.
Hope it makes sense 🙂