Create new aggregated table

Question

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.

stabben23 · Answer

Problem is that this works in Power BI, not Power Pivot.&nbsp;

alb · Answer

Hi Stabben23&nbsp;
Create a calculated table:
NewTable =
SUMMARIZE(Table1, Table1[Items], Table1[ACCMax] )
&nbsp;

Please accept the solution when done and consider giving a thumbs up if posts are helpful.&nbsp; 
Contact me privately for support with any larger-scale BI needs, tutoring, etc.

&nbsp;

stabben23 · Answer

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

alb · Answer

Stabben23&nbsp;
Should work.&nbsp; PRobably you're doing something differently.
If you share the table above in text-tabular format instead of on a pic, I can copy the contents and share back a pbix with the whole thing working.
&nbsp;

Please accept the solution when done and consider giving a thumbs up if posts are helpful.&nbsp; 
Contact me privately for support with any larger-scale BI needs, tutoring, etc.

&nbsp;

anonymous · Answer

You must be using the code while creating a Measure. As mentioned by&nbsp;AlB, use this code in the Calculated Column.Write your query in the DATA field:&nbsp;

Forum Discussion

Create new aggregated table

6 Replies

Related content

Create new table

creating an aggregated table

Lakehouse Table Generate Create Table

Using Aggregate Tables and Partitions

Create rows from 2 tables