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)
happycat59
One Orange Chip
Points: 29387
More actions
April 13, 2016 at 10:10 pm
#1871900
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