Forum Discussion
Solved
Average Transactions Per Hour Measure
Hello, I have a data set that has the following dimensions * Year, Month, Day, Hour * Region, Branch, Employee, Cashbox and a fact table with rows per transaction that has a column [Transactio...
Hi rlussky,
You need create a summary table grouped by each employee per hour, and use Averagex function, just like:
AVERAGEX( filter_table, [[Transaction Count] )Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi rlussky,
You need create a summary table grouped by each employee per hour, and use Averagex function, just like:
AVERAGEX(
filter_table,
[[Transaction Count]
)
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Thanks v-xulin-mstf. The summary table is definitely the diretion I needed to go. I've been away from PBI for almost a year so I'm a bit rusty!