M formula/script for Custom Groups in Query editor?

[Anonymous]

Is it possible to obtain the M script/formula for custom groups previously established?

the reason I ask is I have grouped items in Report A and would like to use the same type of grouping in Report B.

Thanks!

[Anonymous]

@Anonymous,

Right click on the query that contains the grouping step, and select Advanced Editor. You can just copy that grouping step, paste it into the other report, and make changes according to your query.

[Anonymous]

My Custom Grouping was done under "Report View", so no code was generated in Advanced Editor.

[Anonymous · Accepted solution]

Custom Grouping in report view does not generate any DAX or M codes, so you have to replicate the custom grouping in your other report. You can perhaps create custom colums using M codes (preferred) or DAX for grouping, in the event that you need to replicate it in the future reports