Forum Discussion

Tito's avatar
Tito
Helper IV
2 years ago
Solved

Calculate Sum MAX

Hello everyone, Can someone please help me how to calculate the maximum of Sales. See the data below: Data:  Result: Best regards Tito
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi Tito,

    Please try this formula:

    MAX Measure = 

VAR _Table =
     ADDCOLUMNS(
        SUMMARIZE(
            T_MaxQ,
            T_MaxQ[Name],
            T_MaxQ[ID]
        ),
        "@MaxSales",   
		VAR _MAX = CALCULATE(MAX(T_MaxQ[Date]))
		VAR _Result = 
			CALCULATE(
				SUM(T_MaxQ[Sales]),
				T_MaxQ[Date] = _MAX
				
			)
		RETURN
			_Result
    )
VAR _Result = SUMX(_Table, [@MaxSales])
RETURN
    _Result
manvishah17's avatar
manvishah17
Solution Supplier
2 years ago

 

 

HI Tito ,
To get sales by Maximum date you can use this measure,

 

 

SalesByMaxDate = 
CALCULATE(
    SUM('Order Data'[Sales]),
 FILTER('Order Data',
  'Order Data'[Date]
  =MAX('Order Data'[Date])
  )
  )

 

 

  • Tito's avatar
    Tito
    Helper IV
    2 years ago

    Hi manvishah17 

    Thank you!

    Best regards