Understanding Evaluation Context in DAX
The most important concept to understand DAX is evaluation context. This context is used when evaluating calculations to get the result. Some of your calculations …
5 ways to calculate last 12 months in DAX for Power BI
It is common in financial reports to calculate the last 12 months in DAX. This can be achieved in a couple of ways. Each way …
Read more5 ways to calculate last 12 months in DAX for Power BI
Aggregate Text Values Using Group By in Power Query
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
How to use Conditional Formatting based on a Measure in Power BI
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
Optimizing the performance of DISTINCTCOUNT in DAX
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: Tutorial, Example If Statements and Errors Explained (Complete Guide)
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 …
7 Ways to Open Multiple Instances of Excel
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 …
2 Awesome Tips on How to Use the SWITCH Function in Excel
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
3 Ways to SUM null values in Power Query
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 …
How to Calculate Same Day Growth in Power BI
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 …
