Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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
@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.
My Custom Grouping was done under "Report View", so no code was generated in Advanced Editor.
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
User | Count |
---|---|
86 | |
83 | |
68 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |