I'm now studying Excel Power Query. I have a spreadsheet filled with dates and sales from previous transactions. I make a new spreadsheet every month to examine sales information. I have a "setup" sheet for each monthly spreadsheet where I enter the beginning and ending dates of the month as well as the names "from date" and "to date" (my months are not based on actual month start and end).
As a result, I have configured a Power Query query that chooses all of the sales data and filters it based on two empty searches from the two named dates. Although it puts these "blank ranges" into the Excel sheet, this method is effective. Is it possible to prevent this from occurring and limit Power Query to the two named date queries only?