A metric definition changes mid-project. What steps should you follow?

< 1 min read

First, I would confirm the updated metric definition with the stakeholder and understand why the change is required.
I would document the new logic and compare it with the previous definition to identify what parts of the calculation are affected.
Next, I would assess the impact on existing datasets, reports, and dashboards that use this metric.
For example, in one project the definition of “active customer” changed from 30 days to 60 days activity, which affected several reports.
I would update the calculation logic in the data model or transformation layer accordingly.
Then I would test the results and validate the new numbers with sample data and stakeholders.
I would also communicate the change to all users so they understand the updated metric definition.
Finally, I would update the documentation to ensure future reporting follows the new definition.

Power BI Essentials