Beginner

3 posts on Beginner: benchmarks, internals and workarounds for the Microsoft data stack.

1. 03
   Top everyday DAX functions

   The DAX functions worth learning first and what each one is actually for. Not a reference list: the handful you end up using in every model.

   Feb 18, 2025
2. 02
   Ultimate intro to Power Query M Language

   What M actually is, how Power Query writes it for you, and how to start editing it yourself. A beginner introduction built on working examples.

   Feb 7, 2025
3. 01
   Introduction to API in Power Query

   Calling a REST API from Power Query with Web.Contents and Json.Document: the request, the response, and turning JSON into a usable table.

   Nov 9, 2024