Hi all,
I received fantastic help from CK76 to solve my initial problem of extracting/building a weekly dataset from a dataset consisting of daily data in this thread:
Create a data set by extracting data from another data set?
This weekly data consist of the entire week minus Saturday/Sunday. To make matters worse - some days have only 3-4 weeks due to holidays and such. But that was handled.
For statistical analysis, I'm now interested in creating additional datasets which consists of weekly data as the week progresses:
Dataset 1 - Monday
Dataset 2 - Monday - Tuesday
Dataset 3 - Monday - Wednesday
Dataset 4 - Monday - Thursday
Dataset 5 - Monday - Friday: This would be the dataset already created in the prior thread.
According to CK76, this particular problem is best solved using Data Model and DAX. Sadly, I don't have any experience using these tools.
Any pointers on how to proceed?
I realize that this is a task that may be beyond what can be asked for free in a forum. If so - maybe it's possible that I could later post this in the commercial part of the forum, but I would need to buy credits for that and I'm not sure what the price of such a job would be.
Thanks in advance for any help.
Best regards,
Elijah
Bookmarks