Combine Multiple Excel Files from a Folder with Power Query (Step by Step)
Every month you get twelve branch files, or one sales file per day, and someone has to copy-paste them into one sheet…
November 15, 2026Every month you get twelve branch files, or one sales file per day, and someone has to copy-paste them into one sheet…
Personal Blog | Virvijay November 15, 2026IF is the first "smart" formula most people learn in Excel. On its own it checks one condition. Combine it …
Personal Blog | Virvijay November 14, 2026Every Power BI developer hits this question sooner or later: should I create this column in Power Query or with DAX …
Personal Blog | Virvijay November 13, 2026Duplicate rows are one of the most common data problems in Excel. A customer appears twice, an order is copied by mis…
Personal Blog | Virvijay November 12, 2026Real data almost never sits in one table. Customers are in one table, orders in another, products in a third. To answ…
Personal Blog | Virvijay November 11, 2026Before 2019 you needed AutoFilter, helper columns or a long INDEX/SMALL array formula to pull matching rows out of a …
Personal Blog | Virvijay November 10, 2026A table full of numbers is hard to read. Add colour, and the problems jump out: red for regions below target, green f…
Personal Blog | Virvijay November 09, 2026Your report works perfectly in Power BI Desktop. You publish it, set up scheduled refresh, and the next morning you g…
Personal Blog | Virvijay November 03, 2026A Pivot Table is the fastest way to summarise a big list in Excel. In a few clicks you can turn 10,000 rows of sales…
Personal Blog | Virvijay November 02, 2026"Show me our top 5 products" is one of the most common requests in any Power BI report. You can do it with …
Personal Blog | Virvijay November 01, 2026