Similar Posts
ALL, REMOVEFILTERS, and KEEPFILTERS: How DAX Controls Filter Context
Learn how DAX functions ALL, REMOVEFILTERS, and KEEPFILTERS control filter context in Power BI – differences, examples, and when to use each.
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.
DAX CALCULATE: The Most Powerful Power BI Function
Learn how the DAX CALCULATE function works in Power BI – syntax, examples, changing filter context, and common mistakes.
Why It’s Worth Switching from VLOOKUP to XLOOKUP in Excel
Learn why it’s worth switching from VLOOKUP to XLOOKUP in Excel tables – fewer errors, simpler syntax, and more reliable table merging.
Introduction to DAX: What Every Power BI User Should Know
Learn DAX basics in Power BI – calculated columns vs measures, row and filter context, X functions, and Time Intelligence.
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.
