Similar Posts
A Proper Dataset: How to Prepare Data for Power Query
Learn what a proper dataset is for Power Query – headers, merged cells, data types, null values, and one cell, one value.
Date & Time Transformations in Power Query: Types, Extraction, and Locale Errors
Learn how to handle dates and time in Power Query – Date/DateTime type, extracting year and month, creating dates from text, and fixing Locale problems.
How DAX Understands Time: Time Intelligence Made Simple
Learn how DAX Time Intelligence functions calculate YTD, MTD, comparisons to last year, and moving periods in Power BI.
Power Query Folder: How to Automatically Combine Excel Files from a Folder
Learn how the Power Query Folder connector automatically combines multiple Excel or CSV files into one table, and how automatic refresh works.
How to Merge Excel Tables from Different Files with XLOOKUP
Learn how to merge Excel tables from different files using XLOOKUP. Practical example, common mistakes, and tips to avoid errors.
How to Find the Last Match with XLOOKUP in Excel Tables
Learn how to use XLOOKUP with search_mode = -1 to find the last match in an Excel table instead of the first. Practical example and video tutorial.
