group the rows in a table and calculate MINX and MAXX

[ancorte]

Hello, ia have a table like this :

I want group the rows by data and after calculate same values, like average, min e max (for every month) of  "utilizzato"/"operativo",

I dont' know how to make it.... i think that i have to use summarize, or calculatetable.

Is there anyoine that can help me ?

Thanks in advance

[Anonymous · Accepted solution]

Hi @ancorte ,

Create a new table like below.

Table 2 = SUMMARIZE('Table','Table'[Column1],'Table'[Column2],"_sum",SUM('Table'[Column3]),"_avg",AVERAGE('Table'[Column3]))

Best Regards,

Jay

[TheoC]

Hi @ancorte 

You can create a calculated column for the MIN and MAX and AVG etc by group without needing new tables, etc.  You can use something like the following:

Column = CALCULATE ( MIN ( Table[Value] ) , FILTER ( Table , Table[Intermediario] = EARLIER ( Table[Intermediario] ) ) )

Just change the "Table" to your table name. 

Hope this helps!

Theo

[ancorte]

Hi,

yes but i want before summarize the rows for data. In this way i could have a single row for data, and calculate the average, max and min.