Replace confusing cell references with global constants, local variables, and reusable custom functions.

I’ve been working with Microsoft BI tools for 28 years now and for all that time Microsoft has been consistent in its belief ...