Activity analysis for Gaming machines

[JarrettM]

Definitely going to need a proper Date Table in order to do those time intelligence functions. Once you get a Date Table setup and have some questions on your specific Measure(s), we will be glad to help. Here is a link to a recent post that has some good info on how to setup a proper date table.

Calculate totals, pr week without a date in table

Hi, this Works well. But, i run into another problem. In the RevenueBudget data there is 53 weeks, not 52. Week 53 is the last days in december, when the January 1st is in the middle of the week. Any experience how to handle week 53 in a scenario like this ?

Thanks
Jarrett