Creating a 4-4-5 Calendar with Power Query 4-4-5 calendar is a common calendar structure for some industries such as retail and manufacturing. You will need to create such a calendar if you wish to harness
Tag Archives: power query
Power Query: Sort a Column by Another Column This is a follow-up post regarding a solution I provided on this post on Mr.Excel forum. The OP had a table in Power Query where one of
Create a Fixed Length CSV with Power Query The Power Query Combiner Functions can make your life very easy when it comes to turn a table into a fixed length CSV file. The ones I
Concatenate Table Headers with First Row in Power Query Concatenate Table Headers with First Row in Power Query Today I found myself in the situation of dealing with a table like the one below, where
Replicate SUMPRODUCT in Power Query Today I stumbled upon the M function List.Zip which I thought would provide a valid alternative to my previous post about replicating SUMPRODUCT in Power Query. According to Microsoft Power
Replicate SUMPRODUCT in Power Query In my previous post, MMULT in Power Query, I showed how to recreate Excel SUMPRODUCT using List.Generate. This post will show an alternative method using List.Accumulate. Power Query does not come
Replicate Excel MMULT in Power Query When you start getting into Power Query and the M language you realize the immense benefits this tool provides you with. Even the VBA geeks like myself realize that,
List all Files from a folder and all subfolders with Power Query A common task some people have is listing all files within a folder and its subfolders and then sort them by either file
Excel Clock Chart Download the file When we look at a clock, we are looking at the first chart invented by the human kind, so why not build one in Excel? The steps are not