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
Category: 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
One of the key concepts in DAX Context transition is one of the tougher concepts to know and understand well in the DAX language. Why do you even need to know it? Well, if you want to create calculations within calculated columns that reference columns from another table or if you want to run a
The growth opportunity for Power BI is massive I am basically convinced that Power BI is about to explode into the most used enterprise analytical tool around the world in no time. I’m imagining we are out the back of a set of waves, the crest has only just appeared on one, but it will
Just a decade or two ago we were running weekly, monthly and quarterly reports, at the end of each reporting period. Based on previous years and current trends we would try to forecast our revenue, calculate customer churn rate and some even dared try to calculate marketing campaign ROI relying on hefty amount of assumptions.