In this blog post, we provide a practical guide to creating rolling average (i.e., last 30 days) measures in Power BI using the built-in DAX (Data Analysis Expressions) programming language.
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.