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.