Automatically remove empty columns and rows from a table in Power BI
Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns...
Tag: List.Accumulate
Book Excerpt: Loops, Recursions, Fibonacci and more from Chapter 9: M #PowerQuery
The draft of my book is almost ready (I even have few Excel formulas that are showing me, that I have already wrote 93% of the books, and a total of 359 draft...
Split CamelCase headers in M (And a fix for the Record of Promises)
How many times did you have to work with tables that had headers like these? Client_ID, Transaction_ID, Product_Name,...
Automatically remove empty columns and rows from a table in Excel using Power Query
In today's tutorial, we will solve a very common challenge in Excel. You start with an Excel table and you wish to condense it by removing all the columns...
Power Query List.Accumulate – Unleashed
Following a reader's request, today we will unleash the power of List.Accumulate. The official documentation on List.Accumulate here was very confusing for...
