Forum Discussion
MiKeZZa
Post Patron
Post PatronRunning total per customer
I have a working running total per customer, but it gives problems when you have more than 1 customer. The RT makes a cumulative number of months that a customer is with our company. As shown her...
MiKeZZaPost Patron
Post PatronThis seems to work. Why is this?
I can imagine that the datedim goes untill 201803 because of the longest during customer and now it's record per record so its 201803 for 1531 and 201712 for 1533. But what about things as 'make a good model with a starschema' and so on?
How can I tell my powerusers who Analyze in Excel that they don't have to use the datedim here but the datefields from the fact (which is normally hidden because of that I make the measures in a separate table)?
v-cherch-msft
Microsoft Employee
Microsoft Employee