Forum Discussion
Post PatronRunning total per customer
Community Champion
Basically you need to understand how PowerBi deals with this kind of relationships between the tables.
Date table is just a superset (manually specified date ranges) but the actual data is on fact_per_month field which is the one that will give you the information that you want.
Date table normally gives you the option to retrieve date and time related data. These data could have also be taken from fact_per_month table without using the Date table at all.
I hope it makes sense.
Post PatronYes this make sense. At all! This was also what I ment to say. I think I understand the model good enough to understand that the datedim gets all the values that are available in the fact, when you take a date month in the fact t's based on per customer. So that's 100% clear.
But this is a rupture to the statement that PowerBI models must be based on a traditional starschema by favor. And what about special things where a date dim is ment for (lets say; last 13 months, is current year, is current accounting year, quarter and so on).... These kind of reportquestions make a date dim useless I think. That's what surprires me very; the concept is clear to me.