cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Need min, max average, and st dev below table visualization

Hey guys,

Im trying to get my company to move to powerbi but i need to make templates as similar as possible to the former excel templates.  How do I make a simple table visualization with min, max, avg, and stdev "totals" on the bottom.  The data looks like the following:

[ID, Data1, Data2;

1, 334, 132;

2, 337,172]

I want to get the following in the visualization on my report

[ID, Data1, Data2;

1, 334, 132;

2, 338,142;

Avg, 336, 137;

Min, 334, 132;

Max, 338, 142;

STDEV, ?, ?]

1 ACCEPTED SOLUTION
Employee

Hi @mberlinger3,

For your requirement, you need to create a new table, then create the expected report using the new table.

I use your first sample table as screenshot1 shown. Click "New Table" under Modeling on home page, type the following formula, you will get a new table as the screenshot2 shown.

screenshot1

```NewTable =
UNION (
SELECTCOLUMNS (
Table1,
"Data1", Table1[Date1],
"Data", Table1[Date2],
"ID", Table1[ID]
),
SUMMARIZE (
Table1,
"Avg1", AVERAGE ( Table1[Date1] ),
"Avg2", AVERAGE ( Table1[Date2] )
),
"Avg", "Avg"
),
SUMMARIZE (
Table1,
"min1", MIN ( Table1[Date1] ),
"min2", MIN ( Table1[Date2] )
),
"min", "min"
),
SUMMARIZE (
Table1,
"max1", MIN ( Table1[Date1] ),
"max2", MIN ( Table1[Date2] )
),
"max", "max"
)
)
```

Then you can create a table, select all the columns in new table to display.

Best Regards,
Angelia

3 REPLIES 3
Solution Supplier
Hi

How's your data looks like? Can you give some sample data and final expected result?
Frequent Visitor

Dilumd,

I gave a demo above.  I am using the table visualization but I am limited to just a total row.  I would like 4 "Total" rows one for each of the metrics "min, max, avg, stdev"

Mike

Employee

Hi @mberlinger3,

For your requirement, you need to create a new table, then create the expected report using the new table.

I use your first sample table as screenshot1 shown. Click "New Table" under Modeling on home page, type the following formula, you will get a new table as the screenshot2 shown.

screenshot1

```NewTable =
UNION (
SELECTCOLUMNS (
Table1,
"Data1", Table1[Date1],
"Data", Table1[Date2],
"ID", Table1[ID]
),
SUMMARIZE (
Table1,
"Avg1", AVERAGE ( Table1[Date1] ),
"Avg2", AVERAGE ( Table1[Date2] )
),
"Avg", "Avg"
),
SUMMARIZE (
Table1,
"min1", MIN ( Table1[Date1] ),
"min2", MIN ( Table1[Date2] )
),
"min", "min"
),
SUMMARIZE (
Table1,
"max1", MIN ( Table1[Date1] ),
"max2", MIN ( Table1[Date2] )
),
"max", "max"
)
)
```

Then you can create a table, select all the columns in new table to display.

Best Regards,
Angelia

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors