Have you ever felt like your Power BI model is a jungle of measures? One for YTD, another for QTD, one more for MTD, and suddenly you have Measure Overload Syndrome. Don’t worry—you’re not alone. Luckily, Calculation Groups are here to save your model (and your sanity).

When importing data into Power BI, the VertiPaq engine automatically stores column values in a case-insensitive way. In this blog , we’ll walk through a method you can use to retain the original case when importing data, ensuring your column names or values stay exactly as they appear in the source.

As a Data Engineer/Analytics Engineer, one of the most common questions I get asked is, “How do you decide what data goes into the warehouse/model when you’re starting out?” It’s a great question, and the answer is both simple and complex: I go as granular and broad as I can. Why, you ask? Oh boy, let me tell you!