Forum Discussion
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.
Hi, Gives me an error like" reference to many columns..."
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. |