Forum Discussion

Stabben23's avatar
Stabben23
Icon for Helper I rankHelper I
5 years ago

Create new aggregated table

Hi I have a table with values, I want to create a New table that is group by Item. This has to be done as new table because ACCMax is a calculated column with DAX, no Power Query.
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Stabben23 

Create a calculated table:

NewTable =
SUMMARIZE(Table1, Table1[Items], Table1[ACCMax] )

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

Stabben23's avatar
Stabben23
Icon for Helper I rankHelper I
5 years ago

Hi, Gives me an error like" reference to many columns..."