In this post, we show you how to create a dedicated Measures Table to keep your calculations organized, your data model clean, and your workflow efficient. Whether you're working solo or collaborating with a team, this simple trick will save you time, and future-you will thank you.
In this blog post, we explain the difference between Duplicate and Reference in Power Query - both in Power BI and Excel.
In this blog post, we show you how to create year-over-year calculations in Power BI using the built-in Data Analysis Expressions (DAX) programming language.
In this blog post, we provide a detailed tutorial to dynamically replace multiple column values in one step in Power Query using some simple M programming. This data transformation step is applicable in Microsoft Power BI and Excel.
Conditionally formatting line charts in Power BI can be a frustrating experience. Although the tool does not provide a built-in way of doing this – there is a trick! In this post, we walk you through how to conditionally format line charts in Power BI.