Forum Discussion
mizaskun
Helper II
Helper IISummarize by three columns
Good morning, I have the following table: USER | YEAR | REGION | RISK | VALUE A | 2019 | EUROPE | A | 2 B | 2019 | EUROPE | A | 3 C | 2019 | EUROPE | A | 4 ...
Probably best to do this in PQ. If you want it in DAX:
NewTable = ADDCOLUMNS ( SUMMARIZE ( Table1, Table1[YEAR], Table1[REGION], Table1[RISK] ), "@Average", CALCULATE ( AVERAGE ( Table1[Value] ) ) )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.
mizaskunHelper II
Helper IIGood morning,
But I need to create a new table, not in a measure. That is the point.
Thank you!
AlB
Community Champion
Community ChampionProbably best to do this in PQ. If you want it in DAX:
NewTable =
ADDCOLUMNS (
SUMMARIZE ( Table1, Table1[YEAR], Table1[REGION], Table1[RISK] ),
"@Average", CALCULATE ( AVERAGE ( Table1[Value] ) )
)
|
|
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. |