Which sequence correctly retrieves a list of stores opened after a given date by first projecting the Name and OpenDate columns and then applying the date filter?

Which sequence correctly retrieves a list of stores opened after a given date by first projecting the Name and OpenDate columns and then applying the date filter?

• A. SUMMARIZE(Store, Store[Name], Store[OpenDate]); FILTER(Store, Store[OpenDate] >= _SALES_SINCE)
• B. FILTER(Store, Store[OpenDate] >= _SALES_SINCE); SUMMARIZE(Store, Store[Name], Store[OpenDate])
• C. SUMMARIZE(Store, Store[Name]); FILTER(Store, Store[OpenDate] >= _SALES_SINCE)
• D. ADDCOLUMNS(Store, "OpenDate", Store[OpenDate]); FILTER(Store, Store[OpenDate] >= _SALES_SINCE)

Answer: (A)

The sequence relies on shaping the data first and then applying the filter. Start by projecting only the fields you need—Name and OpenDate—so you create a table that contains just those two columns. Then apply the date filter to that projected table by checking OpenDate against the given date. This order ensures you’re filtering the data you actually intend to return and that the OpenDate column used in the filter is present in the dataset you produced. This approach is the best because the other sequences either filter the base table before projection, project only one of the needed fields (missing the OpenDate needed for the filter), or add a column without producing the desired two-column projected result to filter.

The sequence relies on shaping the data first and then applying the filter. Start by projecting only the fields you need—Name and OpenDate—so you create a table that contains just those two columns. Then apply the date filter to that projected table by checking OpenDate against the given date. This order ensures you’re filtering the data you actually intend to return and that the OpenDate column used in the filter is present in the dataset you produced.

This approach is the best because the other sequences either filter the base table before projection, project only one of the needed fields (missing the OpenDate needed for the filter), or add a column without producing the desired two-column projected result to filter.