November 17, 2023 Rick de Groot DAX 1 Understanding Evaluation Context in DAX The most important concept to understand DAX is Evaluation Context. This ... Read more
November 17, 2023 Rick de Groot DAX 11 5 ways to Calculate Last 12 Months in DAX for Power BI It is common in financial reports to calculate the last 12 ... Read more
February 26, 2024 Rick de Groot Power Query 55 Concatenate Text with Group By (Combine Rows) in Power Query In this post, you learn how to group your data and ... Read more
November 17, 2023 Rick de Groot Power BI 5 Apply Conditional Formatting based on a Measure in Power BI With conditional formatting in Power BI, you can apply formatting to ... Read more
November 17, 2023 Rick de Groot DAX 11 Optimizing the Performance of DISTINCTCOUNT in DAX A common operation in Power BI is calculating the Distinct Count ... Read more
July 4, 2024 Rick de Groot Power Query 35 IF Statements in Power Query M (Incl Nested IFs, OR, AND) In this article, we delve into the capabilities of the IF ... Read more
November 17, 2023 Rick de Groot Excel 38 Open Excel files in Separate Instances or Multiple Windows This post describes how to open Excel files in separate instances. ... Read more
November 17, 2023 Rick de Groot Excel 7 2 Awesome Tips on How to Use the SWITCH Function in Excel The SWITCH Function is one of Excel’s logical functions that can ... Read more
November 17, 2023 Rick de Groot Power Query 10 4 Ways to SUM Null Values in Power Query M Trying to sum columns with null values in Power Query but ... Read more
November 17, 2023 Rick de Groot Power BI 6 Showing Negative Numbers Between Parentheses in Power BI Formatting is key in financial reporting. It helps users consume the ... Read more
October 3, 2023 Rick de Groot Excel 2 Advanced Hack: Add References to Cells in Bulk There are times when you want a set of cells to ... Read more
August 2, 2024 Rick de Groot Excel 7 Using SUMPRODUCT with Multiple OR Criteria in Excel (2/2) In previous post you learned how to combine AND and OR ... Read more
