Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
sum({<[año]= {$(= Max([2018]))},[mes]={$(=Max([Month Dimension])},[Month Dimension]=>}[IVTOTAL NETO])
You would need to aggregate per month and use min/max on the aggregated values.
MAX(AGGR( <Your expression >, YearMonthField))