Tag: Writing DAX

How the DAX Calculation Engine Works

Breaking down the way DAX works The DAX engine is a complex beast. How it stores the data, then works through it to calculate answers is quite spectacular. Let’s step back for a moment though and try to distill it down into some simple steps, that we can memorise and intuitively start iterating over when

Continue reading

Formatting DAX Code In Power BI

Effort here will pay dividends later Placing effort into formatting your DAX code will makeĀ a huge difference as you build out your data models in Power BI. DAX, at times is a confusing language as it is, so as soon as you get into the slightly complex territory unformatted DAX code becomes almost impossible to

Continue reading