My original question was not resolved.
What I am really looking for is to load a file lets call 'Data' and it be the data source for 3 different queries without having to load the same data 3 times and use Query Editor to give me 3 similar but different data sets (This comes into play when you load a bunch of files but you only want to retain certain pieces of information from each file based on partitioning the data with the files). I typically build the data loading queries for users but they are not skilled Power BI users so I try to keep the data tables simplified so they are familiar with what they are looking at to allow them to build their reports as needed.
Best example I can give load folder called 'Data' (~30 files).
Table 1: Filter data to leave only Week 1 data for all files
Table 2: Filter data to leave only Week 2 data for all files
Table 3: Filter data to leave only Week 3 data for all files
**I know this can be accomplished without creating three tables but it is easier for the analyst to understand this way rather than seeing all of the data meshed together and having to use filters when building Reports. Just seeing if this is possible.
