Create new aggregated table

[Stabben23]

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]

@Stabben23 

Should work.  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.

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.

[AlB]

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]

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

[AlB]

@Stabben23 

Sure, calculated tables are not supported in Power Pivot.  Why don't you just create a Pivot table?

Otherwise do the whole thing in PQ, ACCMAx and the rest

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.

[saksham_jain]

You must be using the code while creating a Measure. As mentioned by @AlB, use this code in the Calculated Column.

Write your query in the DATA field:

[Stabben23]

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