Skip to main content

Calculated Columns for Copilot Usage Segmentation

This page provides DAX scripts for calculated columns used to segment users by their Copilot usage patterns in Power BI.

RL12W (12-week rolling) Approach

Recommended if the adoption timeframe is longer than 12 weeks, and the goal is to evaluate long term habit formation on Copilot usage.

Definitions

The segment column applies a mutually-exclusive ladder, evaluated top-down (first match wins), so each user gets exactly one label:

  1. Power User: habitual (9 of the last 12 weeks) and averaging 15+ weekly total Copilot actions.
  2. Habitual User: habitual (9 of the last 12 weeks) but averaging < 15 weekly actions.
  3. Novice User: not habitual, averaging 1+ weekly Copilot actions over the past 12 weeks.
  4. Low User: not habitual, with some usage but averaging < 1 weekly action.
  5. Non−user: zero Copilot actions in the past 12 weeks.

RL4W (4-week rolling) Approach

Recommended if the adoption period is shorter than 12 weeks, or adoption is being evaluated as part of an agile pilot program.

Definitions

The same mutually-exclusive, top-down ladder applies; only the habit window changes (all of the last 4 weeks):

  1. Power User: habitual (all of the last 4 weeks) and averaging 15+ weekly total Copilot actions.
  2. Habitual User: habitual (all of the last 4 weeks) but averaging < 15 weekly actions.
  3. Novice User: not habitual, averaging 1+ weekly Copilot actions over the past 4 weeks.
  4. Low User: not habitual, with some usage but averaging < 1 weekly action.
  5. Non−user: zero Copilot actions in the past 4 weeks.

Usage Instructions

  1. Open Power BI Desktop and select your table in Data view.
  2. Download the DAX file you want to use from the links above.
  3. Copy the DAX expression and paste it into Power BI as a ‘New Column’ formula.
  4. Use the resulting columns to analyze and visualize Copilot adoption and habit formation.

Available DAX Files

12-Week Rolling (RL12W) Files:

4-Week Rolling (RL4W) Files:

Creating Total Copilot Actions Column

It may be necessary to create a custom “Total Copilot actions” column in the Power Query step under ‘Transform Data’. Here’s an example M (Power Query) script:

= let
    Source = #"Changed Type", // Update with name of previous step as appropriate
    AddedCustomColumn = Table.AddColumn(
    Source, 
    "Total Copilot actions",
    each [#"Copilot actions taken in Teams"] + 
         [#"Copilot actions taken in Outlook"] +
         [#"Copilot actions taken in Word"] +
         [#"Copilot actions taken in Excel"] +
         [#"Copilot actions taken in Powerpoint"],
    Int64.Type
    )
in
    AddedCustomColumn

Source Files

Need Help?

For detailed usage instructions and additional context, see our Usage Segmentation Guide or visit the source folder on GitHub.

Last updated: Jun 16, 2026 Edit this page on GitHub