Get the max date value from sumarizecolumns

[Neves]

Hello,

I'am making a ssrs report based on a tabularmodel. 
I have used the function SUMMARIZECOLUMNS. This almost giving me the result I want. 

This is my code:

SUMMARIZECOLUMNS (

                                         'Customer'[Name],
                                         'Contract'[Contractnumber],

                                         'Contract'[Date],

                                         'Contract'[Checked],

                                        "Amount",[Number of contracts]

                                        )

The result is as flows 

What I actually need for in my report is as follows:

So I need on line for every name, contract , checked with the SUM of the amount of the lines and The min and max date of those lines.

Is this possible with a DAX code?

[tamerj1 · Accepted solution]

@Neves 

Please try

=
ADDCOLUMNS (
    SUMMARIZE ( 'Contract', 'Customer'[Name] ),
    "Contract", CALCULATE ( MIN ( 'Contract'[Contractnumber] ) ),
    "Checked", CALCULATE ( MAX ( 'Contract'[Checked] ) ),
    "Amount", [Number of contracts],
    "Start Date", CALCULATE ( MIN ( 'Contract'[Date] ) ),
    "End Date", CALCULATE ( MAX ( 'Contract'[Date] ) )
)