Forum Discussion
Slowly changing dimension
Anyone got a good example for this? Employee Start Date End Date A 01/01/15 B 01/03/15 01/05/15 C 17/06/15 I want to know for each date, how...
This isn't a slowly changing dimension, it's a fact table. A dimension describes a fact. A fact is measured and aggregated.
While you might use this table as a dimension to some other fact, when you write measures against it, it becomes a fact table.
Fact tables are aligned with a business process. Your slowly changing dimension may be a dimension to a sales fact. When the process is HR/headcount, then the fact is the employee table.
Your measures and model become much simpler if you restructure your table to be a fact as described in the answer I provided in this other thread.
anyone got a working example in powerbi? I read all the links, but i cant get it working