Using Dax to create a KPI
Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper. When I got to this slightly more advanced understanding of FP&A, I started to see the field as more than just a budget template architect and filler-inner.
Every company has a unique set of levers based on what’s essential to it, which is ideally found in its mission and values statements. These levers exist in my daughter’s weekend lemonade stand, multi-billion-dollar Fortune 500 companies, and everything in between. It’s not a question of whether they exist, but how they are recognized, organized, and deployed. Recognition is corporate culture—how is the mission written and how do day-to-day operations fit into it? The organization is the analytic dimension around a KPI. Deployment is how the lever is communicated and reinforced on a regular basis. For this post, my focus is on the organizational aspect.