Get the max date value from sumarizecolumns

Neves — Thu, 16 Jun 2022 13:23:06 GMT

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?

Re: Get the max date value from sumarizecolumns

tamerj1 — Thu, 16 Jun 2022 14:38:21 GMT

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] ) ) )

topic Re: Get the max date value from sumarizecolumns in DAX Commands and Tips

Get the max date value from sumarizecolumns

Re: Get the max date value from sumarizecolumns