Parameter Tables
The final group of M queries, parameter table queries, are developed for usability and manageability purposes. From a usability standpoint, the Date Intelligence Metrics and Adventure Works Sales queries serve to consolidate similar DAX measures in the Fields list. Additionally, the CurrentDate query is used to provide reports with a text message advising of the latest data refresh date. From a manageability standpoint, the Measure Support query can be used to centralize intermediate or branching DAX expressions that can be referenced by many DAX measures.
As shown in the following example of the Adventure Works Sales query, a trivial expression can be used for three of the four queries since the purpose of the query is simply ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access