Most users know the Group By function in Power Query. It allows you to summarize data and aggregate underlying values. The standard aggregations are Average, …
Read moreAggregate Text Values Using Group By in Power Query
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 …
When you work with multiple workbooks in Excel, you may sometimes experience issues. During a resource intensive task in one spreadsheet, other spreadsheets within the …
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
Getting unexpected results when summing up null values in Power Query is something beginners bump into all the time. And the reason for this is …
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. …
