Forum Discussion
How to control output column names when using DAX GROUPBY and aggregated columns
When you use GROUPBY in isolation, the output column names are simply the same as the column names you specified.
eg Newtab = GROUPBY(table, table[colA], table[colB]) yields a table with columns call colA and col B
But when you add an aggregate column: Newtab = GROUPBY(table, table[colA], table[colB]),"agg_col",
Hi Anonymous ,
Have you looked into SUMMARISE function in Power BI which allows you to give custom names to the resulting columns?
https://radacad.com/aggregated-table-in-power-bi-summarize-function-in-dax
Thanks,
Pragati
2 Replies
- Pragati11
Super User
Hi Anonymous ,
Have you looked into SUMMARISE function in Power BI which allows you to give custom names to the resulting columns?
https://radacad.com/aggregated-table-in-power-bi-summarize-function-in-dax
Thanks,
Pragati
Yes SUMMARISE works well for me thank you. I don't anything else GROUPBY gives.
Just as a supplemental (and I am happy to create a new thread): I can't specify MODE as an aggregate function. It would help me a lot if I could. Or is there a way of building a user-defined MODE function that I can use in SUMMARIZE?