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.
Stabben23's avatar
Stabben23
Icon for Helper I rankHelper I
5 years ago

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

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

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.