Values of a max and min date

[BLM]

Hi!!

I`ve a table whit two fields: one it`s a date and the  other a integer.

I would like obtain the value of the max and min date.

I've attached a example:

thank u

[v-chuncz-msft · Accepted solution]

@BLM,

You may refer to measures below.

Max =
CALCULATE ( SUM ( Table1[Kg] ), LASTDATE ( Table1[Date] ) )

Min =
CALCULATE ( SUM ( Table1[Kg] ), FIRSTDATE ( Table1[Date] ) )