Calculating Max of a column with grouping based on dates

[metin]

Hi All,

I have an inventory table showing inventory status of products historically. Table looks like as below.

Product - Quantity - Inventory Date

Prod. A - 10 - 21.12.2020

Prod. B - 5 - 21.12.2020

Prod. A - 15 - 14.12.2020

Prod. B - 1 - 14.12.2020

Prod. A - 5 - 7.12.2020

Prod. B - 15 - 7.12.2020

The two measures I would like to get is, total max / min inventory value based on dates.

On this example total inv. value on each date is,

21.12.2020 - 15

14.12.2020 - 16

7.12.2020 - 20

So I expect the max measure to give me the result of 20 (which is 7.12.2020) and min measure to give me the result of 15 (which is 21.12.2020).

Looking forward to hear your suggestions & ideas.

Thanks,

Metin

[metin]

@amitchandak Thanks a lot, it is working very well. And one more question, how can I show the date of max or min inventory (from example I would like to see 21.12.2020)?

[amitchandak · Accepted solution]

@metin , Try a measure like

maxx(values(Table[Inventory Date]), calculate(Sum(Table[Quantity])))