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