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.
Are your teams spending too much time in Excel? Is your business drowning in data but starving for insights? These are just a couple among a list of signs that it’s time to upgrade from manual, spreadsheet-based data analysis to Power BI.