Similar Posts
What Is Report Automation? Excel Report Automation
Find out what Report Automation is and how to automate Excel reporting using Power Query. Less manual work and faster reports.
How to Return Multiple Columns at Once with XLOOKUP | Excel Example
Learn how to return multiple columns at once with the XLOOKUP formula in an Excel table. Practical example, common mistakes, and a video tutorial.
DAX COUNT Functions: Which One to Choose
Learn the differences between DAX COUNT, COUNTA, COUNTROWS, DISTINCTCOUNT, and COUNTX functions in Power BI – and when to use each.
The Power BI Process: Power Query, Data Model, DAX, and Visualizations
Learn how the entire Power BI process works – from data preparation with Power Query, through the data model and DAX calculations, to visualizations and KPIs.
Text Transformations in Power Query: 6 Steps You’ll Use Most Often
Learn the 6 most commonly used Power Query text cleanup steps – Trim, Replace Values, Extract, Split Column, Format, and Column From Examples.
Conditional Column vs Custom Column in Power Query: When to Use Which
Learn the difference between Conditional Column and Custom Column in Power Query – when to use which, practical formula examples, and a common mistake.
