Create a data set by extracting data from a table? - Part 2. Partial data. DataModel. DAX.

Originally Posted by CK76

To clarify, analysis, slicing/dicing of data is best done in DAX.

However, if you are doing statistical analysis on returned table using some other tool. PQ is still the solution

Hi, CK76,

Many thanks for your continued assistance.

Yes, in the end, I want this dataset as a simple table in Excel like the one you created for me yesterday.

I have an auto-filter macro which lets me filter dates/weeks from say dataset 2 in dataset 5. This will be my approach in order to perform analysis, i.e., filter a partial week dataset and find the result of the final completed week to see if I can find anything interesting.

One clarification is needed. For each data set, should it include the specified weekday for each week? Resulting in some week's being skipped.
I.E. For Dataset 1. Monday only for each week returned.

Important question, yes.

Certainly, several weeks should/will be skipped when looking at Dataset 1 (Monday only) if there is no Monday in a particular week.

When looking at Dataset 2 - I envision excluding all weeks which don't have a Tuesday.

When looking at dataset 3 - I envision excluding all weeks which don't have a Wednesday.

Etc.

In summary, I think the default option would be to skip all weeks on data set 1 without Mondays, on data set 2 without Tuesdays, ..., on data set 4 without Thursdays.

Another important distinction may be to add a column which tells what the first day of a given week is. That way, I can have the option to exclude weeks that don't start on a Monday when filtering.

If you can mock up manually created sample of each type (with about 5 rows) using same source data. It would make it easier to help.

Certainly!

But it will likely take me some time, so I will not be able to produce anything until later tonight at best. Busy helping out my parents at the moment.

Best regards,

Elijah