Forum Discussion
Post PatronRunning total per customer
Post PatronMy PBIX (anonymized) is here: https://ufile.io/0btas
What you see is that when somebody isn't in the dataset anymore in a specific month he does still count in the next month(s). That's not as intended to be.
See client 1531; he is gone in after 201803. From there on I except 0 in april, but it does count 456 for every month. So it is doing what a normal RT needs to do, but I want it to go to 0 from april.
- themistoklis
Community Champion
I think you should modify the X Axis.
Create a new year-month column (on fact_per_month table) which comes from datum and not date and then add it to the chart
Column = FORMAT(fact_per_month[datum], "MMM YYYY")
- MiKeZZa
This 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-msftMicrosoft Employee
