Sergio, thanks for your suggestions. Indeed there are different ways to show the new customer count for different scenarios. What I am unsure is should NewCustomer column be in fact...

Yes, adding a column in fact table and setting its value to 1 can be a solution when the customer is counted new only for once in the lifetime. In...

Thanks for swift reply!

My fact is periodic snapshot and contains monthly snapshot record of customers. A customer is the new customer of any month when he enters the system for...