Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Cemep
Contributor II
Contributor II

MAX - Month - year - sales

hello 

I need to calculate the maximum sales value based on a month

sum({<[año]= {$(= Max([2018]))},[mes]={$(=Max(NUM(0,12)))}>}[IVTOTAL NETO])  no work 

ej fact.jpg

Labels (3)
2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try:

sum({<[año]= {$(= Max([2018]))},[mes]={$(=Max([Month Dimension])},[Month Dimension]=>}[IVTOTAL NETO])  

Vegar
MVP
MVP

You would need to aggregate per month and use min/max on the aggregated values. 

MAX(AGGR( <Your  expression >, YearMonthField))