
Ultimate access to all questions.
You are designing a dynamic reporting solution in Microsoft Fabric for a retail company that requires end-users to interactively select date ranges for sales analysis. The solution must support scalability, minimize maintenance, and ensure data accuracy. Considering these requirements, which of the following approaches is the BEST to implement field parameters for date range selection in the semantic model? (Choose one option)
A
Develop individual measures for every conceivable date range combination, enabling users to select from these predefined measures.
B
Utilize the PARAMETER function in DAX to create a dynamic date range parameter that can be applied across various calculations and reports.
C
Add a calculated column to the date table that categorizes dates into predefined ranges, limiting user flexibility to these static options.
D
Rely on manual adjustments to the report's date filters each time a user requests a different date range, ensuring precise control over the data displayed.