Home Forums Data Warehousing PowerPivot create summaries in DAX in Excel/PowerBI (not Analysis Services) RE: create summaries in DAX in Excel/PowerBI (not Analysis Services)

  • Sure this is simply the MAX aggregration. Click on the column name and select "MAX" from the aggregation tool bar item. This default to SUM...change SUM to MAX and away you go