Hi all,
So, I received fantastic help beyond my wildest expectations from CK76 in two prior threads. By the way, CK76 - I've already found this data very useful and interesting, so thanks again!
Basically, what was done was to create weekly data sets based on daily data (one day = one row),i.e., 5 rows of data were transformed into 1 row. Not only that, but also data set consisting of partial weeks, i.e., a week consisting of for example Monday-Tuesday, Monday, Wednesday, etc. Excellent.
Create a data set by extracting data from a table? - Part 2. Partial data. DataModel. DAX.
Create a data set by extracting data from another data set? Probably complicated...
I have since this realized that it would be very useful for me if I could have the data 'the other way around' as well - with weekly data integrated into my daily data set.
Current data set looks like this:
1.png
I was wondering if this could be transformed into this:
2.PNG
The problem is of course that not all weeks have 5 days. Because of that - no generalized formula can be used for each day.
I'm sure this won't be easy to accomplish. I'm not even sure it will be useful. But it's one of those things you never know until you try, I guess.
Thanks so much in advance.
Elijah
Bookmarks