
Ultimate access to all questions.
You have been tasked with creating a DAX measure to calculate the average overall satisfaction score from survey data. Here is the context for the tables involved:
The third question in each survey specifically asks for the customer's overall satisfaction score. Customers can submit a survey following each purchase. The data should be filtered to include only the surveys from the last 12 months, with this period being defined by the variable Period.
How should you complete the DAX code to achieve this? Choose the correct options in the provided answer area.