Mastering Microsoft Power BI

Measure groups

The Date Intelligence and Adventure Works Sales tables only serve to provide an intuitive name for users to find related DAX Measures. For example, several of the most important DAX Measures of the dataset will include both Internet Sales and Reseller Sales. It wouldn't make sense for these consolidated measures, such as Total Net Sales, to be found under the Internet Sales or Reseller Sales fact tables in the field list. For similar usability reasons, the Date Intelligence Metrics provides an intuitive name for users and report developers to find measures, such as year-to-date, prior year-to-date, and year-over-year growth. The two parameter tables, Date Intelligence Metrics and Adventure Works Sales, effectively serve as ...