We thought that DAX was the thing in Power BI. Alex proves the M-M-Magic is really with Power Query! If you wanted to be blown away but what Power Query can do, this is the video for you!
Power Query folding
30 Day Challenge: Query Folding
Power Query M function reference