James McGillivray

You’ve built a perfect Star Schema, and your data models are performing amazingly… but now you’re starting to run into business questions that the model isn’t designed to answer. How do you create measures for metrics that don’t fit into a star schema?

In an era of relentless technological advancements, the data landscape is evolving at an unprecedented pace. Staying ahead requires more than just individual effort—it demands the collective wisdom, support, and innovation found within a strong community.

Have you ever watched a demo of DAX functionality, and marvelled at how simple the language is, but yet, when you work on your own data model, it just doesn't work as expected?

One of the simplest ways to enhance the value of the information we provide is to add context. Supplementing each data point with information from a larger data set is a common way of adding this context.