Forum Discussion
Slowly changing dimension
Something like this should work:
Column = COUNTROWS(FILTER(FILTER('enddates', EARLIER('enddates'[Start Date])>'enddates'[Start Date]),ISBLANK([End Date])))+1
Would it be possible to put this into an example? I uploaded an pbix below.
In your solution, i dont see any reference to a calender table. And i don't see how i will get a bar for each day.
Perhaps i should rephrase my question?
i have to dates in a record:
IDStart End 01-01-2015 31-12-2015
I wan
Perhaps i should rephrase my question?
i have to dates in a record:
ID Start End 01 01-01-2015 31-12-2015
I want a record for each day
ID Date 01 01-01-2015 01 01-02-2015 01 01-03-2015 ..... 01 30-12-2015 01 31-12-2015
And then for each unique ID
Perhaps i should rephrase my question?
i have to dates in a record:
ID Start End 01 01-01-2015 31-12-2015
I want a record for each day
ID Date 01 01-01-2015 01 01-02-2015 01 01-03-2015 ..... 01 30-12-2015 01 31-12-2015
And then for each unique ID
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
