I have been blogging about DAX since before Power BI was a product; I started back in 2014 and Power BI was first released as generally available in mid 2015. Until about 2017, the only way you could build a commercially viable production reporting tool that used DAX was via […]
This is the longest running blog post series I have on my website. Why does Power Pivot Crash so often and what can I do about it? I have three previous articles that you can read in the links below Original post (Oct 16): Does the Power Pivot Excel Add […]
When I was at the Microsoft Data Insights Summit last week I took the opportunity to catch up with Howie Dickerman to get an update on how the bug fixing with Power Pivot for Excel is coming along. I talked about this in my original blog here and then my […]
Level: Beginners Today Avi Singh and I met with Howie Dickerman from Microsoft to discuss the Power Pivot for Excel Add-In. You can read the background to this meeting at my blog post last month. Howie is the Program Manager assigned to Power Pivot for Excel and has a wealth […]
In this post I cover everything you need to know about the Power Pivot 2013 Update (December 2014), how to get, and what can go wrong. As you may have heard, Microsoft has released a number of patches that improve the stability of Power Pivot, Power View and Power Map […]
I’ve been pretty busy over the last few months. The demand for Power BI skills has never been stronger, and my company is super busy. I haven’t written a blog article for a while, but I wanted to take a bit of time out this morning to talk about the […]
Supercharge Power BI Online Training Power BI is better when you learn to write DAX With the right Power BI online training course anyone can learn to use Power BI. But if you want to Supercharge Power BI, you really need to learn the data modelling language of Power BI, […]
I first wrote this article back in Feb 2017 to be a definitive list of the top reasons why you should learn how to use Power BI in your organization (in case you haven’t already made the decision to do so). In fact there is only one thing that worries […]
I am proud and excited to announce that I have again updated my best-selling DAX book Supercharge Power BI, now in its 3rd edition. This book as a long history: First released back in Sept 2015 under the title “Learn to Write DAX”. Updated in June 2018 (2nd editions) in […]
As my regular readers may know, I am the co-organiser and co-founder for the official Power BI User Group here in Sydney. During the period where COVID has impacted our ability to congregate face to face, Iman and I have been running virtual, online meetup events. Last week I presented […]
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 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 […]
History of Switch Measures in Power BI Using a switch measure to toggle results is a mature and common technique used in Power BI and Power Pivot for Excel. For example, a switch measure can be used to toggle what appears on a chart so that the end user can […]
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 was delivering an advanced DAX class recently and was chatting with the bright students in the class about various topics. Through the discussions it occurred to me that it may be possible to create a compound join between 2 tables using a combination of the inactive relationship feature and […]
Note: This is copied onto the original Post – How and Where to Get Help for Power BI Level: Beginners/Intermediate Regardless of what stage you are at in your Power BI/Power Pivot/Power Query journey, at some stage you are going to need some help. Believe me I am no different to […]
Edit: Sep 2019 Power BI is an enigma. On the surface Power BI is an alluring product that promises to change your world of data analytics for the better – and indeed it can and will. But sitting just beneath the surface, hidden from view, is the reality that there […]
Way back in 2014 I decided to check out what Google Trends had to say about Power Pivot and Power Query global Interest. In case you don’t know, Google Trends will show you the relative frequency of people searching for certain words – it is a good indicator of interest […]
Level: Intermediate A couple of weeks ago I posted a list of my ideas that I have created at ideas.powerbi.com and asked you to vote for them if you agree with the concept (please go back and take a look if you missed it). I thought it would be interesting […]
After what seems like a lifetime of waiting for the paperback book economy to tick its required boxes, both of my new books Supercharge Excel and Supercharge Power BI are now available to ship to most countries in the world from Amazon.com. This is a good opportunity for me to […]
Excelerator BI | © 2023 | Sitemap