PASS logo

November 15-18

Seattle & online

2021 Summit video library

4 Useful DAX Solutions for Business Problems

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? How do you join on a range? What are non-numeric measures, and how can you create them? In this session, we will look at different scenarios which require these types of solutions, and how to create measures that implement them without compromising on a well-designed data model.