Forum Discussion
Stabben23
Helper I
Helper ICreate 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
Community Champion
Community ChampionHi 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. |
Stabben23Hi, Gives me an error like" reference to many columns..."
- Stabben23
Problem is that this works in Power BI, not Power Pivot.
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:- AlB
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.