Time intelligence is the most typical type of analysis you do. That’s why DAX has a section of calculations specifically catered toward ‘Time Intelligence’. Seeing calculations and comparing calculations over time is very common no matter what industry or function that you work in. I thought it would be a good idea to run through
Category: Enterprise DNA
Users of Power BI will quickly find one drawback to making compelling reports and dashboards, and it all has to do with colours! Unfortunately, the team at Microsoft have not quite yet worked out how to include themes into Power BI desktop and the online service. No doubt they will look to remedy this as
Every consumer goods company needs this If you sell a product, good or service, you will no doubt want to be able to draw up some analysis on how you are going. What products are selling to which customers in what locations? Which warehouses or factories are producing them? How are we performing over time?
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
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