MAX Sales in a period of time

[EstherBR]

Hi, 

I have this table and I would like to create a KPI that shows me the max sum of sales of the calendar date:

The max sales KPI gives me 135, but it should give me 369 that is the maximum sum of sales in the period selected.

How can I achieve that?

Thanks!

[OwenAuger · Accepted solution]

Hi @EstherBR 

I would recommend you create these measures, assuming 'Calendar'[Date] is the relevant date column:

Sales Sum =
SUM ( 'Product'[Sales] )

Max Sales by Date =
MAXX (
    VALUES ( 'Calendar'[Date] ),
    [Sales Sum]
)

Does this work for you?

[KarinSzilagyi]

Hi @EstherBR 
You need to use MAXX(), which creates a virtual table and iterates over each date to get the daily sales value, then picks the maximum of those values.

Max Sales in period = 
MAXX (
    VALUES ( 'Dim_Date'[Date] ),  
    [TotalSales]                  
)