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...
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:
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