To help you navigate the website, you can find all website articles organized by their categories.
Power Query Articles
- Lists in Power Query M / List Functions (200+ Examples)
- Mastering List.Sort in Power Query M: Comprehensive Guide
- Remove List Items by Positions in Power Query
- 3 Ways to Select List Items by Position in Power Query
- List Multiplication by Index Position in Power Query
- Generating Random Numbers in Power Query
- Creating Sequences in Power Query
- Text Functions in Power Query M (150+ Examples)
- Wildcards in Power Query M
- Concatenate Text with Group By (Combine Rows) in Power Query
- Concatenate Values in Power Query
- Extract Date From Text String in Power Query
- Pivot Text Values in Power Query – Explained
- Mastering Custom Format Strings in Power Query M
- Create a Date Table or Calendar in Power Query M
- Create a Date Table with Dynamic Language in Power Query
- How to Create Today’s Date in Power Query M
- Create a Fiscal Calendar in Power Query
- Date Table with Monthly Increments in Power Query
- Last Refresh DateTime in Power BI (w/ Daylight Savings)
- Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI
- Create ISO Week and ISO Year in Power Query M (ISO 8601)
- Working Days between Dates in Power Query (DATEDIFF)
- Calculate Nth Business Day From Date in Power Query
- Return Next Working Day in Power Query
- Date Formatting in Power Query – Master 18 Custom Formats
- Creating Julian Day Numbers
- Converting between Julian and Gregorian Dates
- List.Generate in Power Query: Tutorial with Easy Examples
- How to use List.Generate to make API Calls in Power Query M
- Compute a Running Total by Category in Power Query
- Create Running Totals in Power Query M (Ultimate Guide)
- Demystify List.Accumulate in Power Query (Step-by-Step Guide)
- Understanding Recursion in Power Query: Tower Of Hanoi
- Removing Excess Spaces Between Words in Power Query
- Removing Duplicates in Power Query (Complete Guide)
- Unpivot Columns And Keep Null Values in Power Query
- Transform Stacked Column into a Table with Power Query
- Import Multiple Files from a Folder with Power Query
- Grouping or Summarizing Rows in Power Query
- How to Group By Maximum Value using Table.Max – Power Query
DAX Articles
Power BI Articles
- Best Resources to Learn Power BI in 2023 (incl DAX, M)
- How to Display Negative Numbers Between Parentheses in Power BI
- Set Default Slicer Value to Current Month in Power BI
- How to use Conditional Formatting based on a Measure in Power BI
- Best Ways to Share Reports in Power BI
- Comparing Power BI Licenses
Excel Articles
- An Intro to Cube Functions for Power Pivot in Excel
- How to Use the Data Model in Excel
- Beginners Guide: How to Use the SUMPRODUCT Function in Excel
- How to ROUND to Nearest 1000 in Excel
- Advanced Hack: Add References to Cells in Bulk
- SUMPRODUCT with Multiple OR Criteria – Part 1/2
- SUMPRODUCT with Multiple OR Criteria – Part 2/2
- Open Excel files in Separate Instances or Multiple Windows
- 2 Awesome Tips on How to Use the SWITCH Function in Excel
- How to Use SUMPRODUCT With Multiple AND Criteria