Default Summarization

  • Text and date data type columns are set to Don't summarize by default when first loaded to Power BI models
  • These data types also have calculations that can be defined as a secondary option on the report canvas
    • Text: First, Last, Count (Distinct), or Count
    • Date: Earliest, Latest, Count (Distinct), or Count
Summarization options of Date data type column set to Don't Summarize

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.