Latest post out on the Power BI blog out now! Comparing totals this year to last year is a pattern you will use many times over with Power BI. It is always a good benchmark when looking to analyse how a certain metric is performing in the business. Click here to jump over to the
DAX time intelligence functions are widely used in Power BI. 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
Power BI percent of total is a really common calculation that we require quite often. This is great to quickly show where the larger portion of results sit versus the entire population. Completing this in Power BI does not require much written code, but it does require some understanding. It will generally be one of the
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
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