Forum Discussion

Responsive Resident

4 years ago

Solved

Create a table from existing table with count of items

Hello - I have a table with Work Order IDs and Items for each work order. I need to create a new table that summarizes the count of items by work order ID. OriginalTable: I need a tabl...

Need Help

tamerj1

4 years ago

Hi ConnieMaldonado
Please try

New Table =
SUMMARIZE (
    OriginalTable,
    OriginalTable[Work_Order_Id],
    "ItemCount", COUNTA ( OriginalTable[Item] )
)

ConnieMaldonado

Responsive Resident

4 years ago

Thanks so much for this! It worked perfectly.

Forum Discussion

Create a table from existing table with count of items

Related content

Cannot create liquid clustering on existing unpartitioned table

Lakehouse Table Generate Create Table

Create a new table from columns from existing tables

Create new table

create table from existing table