With conditional formatting in Power BI, you can apply formatting to your values based on conditions. For example, you can format a cell’s background based …
Read moreHow to use Conditional Formatting based on a Measure in Power BI
A common operation in Power BI is calculating the Distinct Count of a column. You may, for example, want to show the number of unique …
The IF function in Power Query is one of the most popular functions. It allows you to make comparisons between a value and what you’re …
This post describes how to open a new instance of Excel. When working with multiple workbooks in Excel, you may sometimes experience issues. During a …
The SWITCH Function is one of Excel’s logical functions that can function as an alternative to the conditional if-statements. Many excel users use if-statements to …
Read more2 Awesome Tips on How to Use the SWITCH Function in Excel
Trying to sum columns with null values in Power Query but getting unexpected results? It is something beginners bump into all the time. And the …
When doing analysis it important that numbers are comparable. After all, you want to know how a company performs. And these comparisons are not always …
Formatting is key in financial reporting. It helps users consume the data in a pleasing way. One aspect that is often looked at in Balance …
Read moreHow to Display Negative Numbers Between Parentheses in Power BI
There are times when you want a set of cells to reference a parameter. For example, you’re budgeting and the result needs to be dynamic. …
In previous post you learned how to combine AND and OR criteria for SUMPRODUCT. The approach results in a long and difficult to maintain formula. …
