Duplicating drivers
Duplicating a driver is a fast way to create a new, independent driver with the same formulas, segments, and values as the original.- Use the shortcut:
cmd
orctrl
+D
- The new driver will have “Copy” appended to the name.
- It’s completely separate from the original—no link or dependency remains.
- Any segments from the original driver are also copied over to the new one.
If you find yourself duplicating drivers often and swapping out logic, this might be a sign your use case is a good fit for dimensional modeling in databases, as this is much more scalable.
- Make a new driver with the same name.
- Right click the new driver, and link them under Dimensions > “Make Subdriver of”, and then select the set of existing drivers
Removing vs. deleting drivers
You have two options when you no longer need a driver in the table you’re working in:- Remove from block (shortcut: ⌫) — Removes the driver only from the current view. The driver will still exist in other tables where it’s used, and any formula references will remain intact. This is not a destructive action and will not impact your model.
-
Delete (shortcut: ⇧ + ⌫) — Removes the driver from the entire model and all tables it appears in. Any formulas referencing this driver will break. This is a destructive action and applies to the current scenario you’re working in.
