New table based on existing table

[Kristofferaabo]

Hi,

I have a large data table I use for me analysis, I would like to make a couple of tables based on the 'master' table.

My main table is called MASTER, and the column I need in this new table is called 'project code' followed by:

1. Several date columns that should either be MIN or MAX (earlist/latest)

2. A couple of numeric columns that sould be used as COUNT or MAX

Normally I would do this as a pivot table in excel, but I have read this can be done in DAX via SUMMARIZE?

Thanks

Kristoffer

[Greg_Deckler]

Yes, correct, in the Model tab you can select New Table and then put in a formula using SUMMARIZE and/or ADDCOLUMNS.