This is a follow up article from my last blog post where I demonstrated how easy it is to use two slicers to compare any two items. In the demo in my article, I specifically showed how you could compare any 2 years of choice, but the principle applies to […]
I have been increasingly recording videos as my method of sharing tips and techniques for getting more out of Power BI. Some concepts are best documented (traditional blogging) and some are just easier for everyone if it is a video. That is the case again for today. Compare Any Two […]
To celebrate the release of the third edition of my book Supercharge Power BI, I plan to hold a live webinar this coming Thursday pm (US time), Friday morning Australia/NZ time. Sorry, it will be very late for Europe. I plan to cover 1 topic from my book, and I […]
I blogged about how to Build a P&L With Power BI back in April 2020, and the response from my readers was great. Several people asked how to add percentages such as % of net sales revenue, % gross profit, etc. into the P&L. I decided therefore to do a […]
Well I am pretty excited to let you know that we (Ken Puls, Miguel Escobar and I) have launched our brand new website for Skillwave.Training. We are dedicated to providing you with the best possible learning experience and have completely revamped the look and feel of our website. We also […]
Power BI Desktop is a free, standalone self service BI tool for data modelling and reporting. You will not get a better, free desktop data modelling and reporting tool than this anywhere. Power BI Desktop is evolving at a rapid rate with updates released every month. Due to the […]
Level: Beginners First posted May 2015, Updated Feb 2021. Many aspects of this article also apply to Power Pivot for Excel. Technically you don’t need calendar tables to use Power BI. Power BI comes with an inbuilt date capability called “Auto Time Intelligence”. But the inbuilt capability is very basic, […]
Level: Intermediate DAX is a tricky language; on the surface it is deceptively simple, but under the hood it can quickly become complex and it can take many years to master. If you have ever typed a formula and crossed your fingers when you press Enter, then you know what […]
Level: Beginners The objective of this article is to help you understand the differences between shaping your data (using Power Query) and modelling your data (using the modelling tools inside Power BI). You will need to do both to build a robust Power BI report. I first wrote this article […]
One of the commercial services I offer is to complete a health check of Power BI deployments. I look at everything including the data model, the DAX, the queries, the distribution approach, and other things to help you polish your work. I thought I would share with you one of […]
Level: Intermediate Updated: 10 Nov 2020 I first wrote this article about how to import Tabular Data from Power BI into Excel back in Jan 2017. The benefits of extracting tabular data are still the same as they were back then however the process of extracting the tabular data from […]
Note: This Affordable Power BI Premium article was first written in March 2019, then updated in Nov 2020 to update the changing licencing information that is available to me. I have long been frustrated by the lack of a suitable scalable Power BI pricing model for small to medium sized […]
I have written a few articles that are related to this topic (articles that utilise this same technique to solve a problem), but never before have I explained the stand alone concept of how to build a visual with asymmetrical columns and rows in Power BI. Let me explain with […]
If you don’t know (or are not 100% sure) what a Power BI Data Model is, you have come to the right place. I see a lot of people confused as to this term “data model”, and frankly I don’t blame anyone for being confused – it’s a foreign concept […]
This is an off topic post for me (ie not Power BI), but then again – who doesn’t want to be more productive, right? I am a heavily process driven person and I like to organise and plan my days, weeks and months so I can be as productive as […]
I have to admit, I never thought that a Power BI Podcast could be a thing, let alone a valuable thing. After all, Power BI is a very visual and interactive tool. But indeed, Power BI Podcast IS a thing invented by my friend and Microsoft MVP Lars Schreiber from […]
This article is a follow on from last week. I recommend you go back and read the article first if you missed it, but in summary, I want to write a measure (not a calculated column) that will return the median sales of products while excluding the products with blanks (no […]
The July 2020 version of Power BI Desktop released a new feature called the External Tools toolbar. This was announced back in May during the Microsoft Business Applications Summit, and I have been waiting eagerly for it to be released ever since. In this short article today I am going […]
I have learnt a lot over my 50 something years in life, and one of my greatest learnings is that “it doesn’t matter how much you already know, there is still more to learn”. Hopefully this is one of the reasons you read my blog – because you want to […]
I was helping a client this past week to calculate the total business hours between a start date/time and an end date/time, taking into account the working days, public holidays and non-working weekends, etc. As is often the case, I thought it would be a great blog article that I […]
Excelerator BI | © 2023 | Sitemap