Really enjoyed your most recent video:
As always, your explanations were really clear and I understand now how to accomplish the topic task.
However, in watching it I realized that I don’t understand how Power BI processes M code. Unlike DAX, which processes roughly outside-in, I had assumed that M code processed sequentially top-to-bottom (like R code). However, that can’t be the case since in your video, you referenced the CurrentDate variable before you declared it, and that worked fine.
So, given that,what’s the order of processing of M code and what are the implications? (i.e., what HAS to be done before what?).
Thanks for clarifying.