I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s […]
Tabular Editor is a Power BI Tabular Modelling productivity tool developed by Daniel Otykier. I blogged about Version 2 of the Tabular Editor in this article here. The 3rd edition of Tabular Editor has just been released, and it is a major upgrade from version 2. TE 3 is not […]
This is the third article where I have covered building a P&L in Power BI. My first 2 articles here and here focused on how to use the DAX language to solve some of the common problems with P&L reporting, such as adding sub totals into the visual, % of […]
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 […]
This is an update to an article that I wrote back in 2019. This time around I created a video to go along with the written explanation and documentation below. You can jump straight to the video below if you prefer that medium. What is Calendar Over Run? Consider the […]
A client recently asked me if it was possible to build a Power BI report using data from a Microsoft Form. I have come across this question a few times now, and you could be excused for thinking this would be a straightforward task. Despite the fact that Microsoft has […]
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 […]
One interesting trend I have seen over the last 12 months is the creation of a lot more non-technical Power BI content on the web. Adam Saxton and Patrick LeBlanc were early adopters of this format with their YouTube channel “Guy in a Cube”. More recently there have been new […]
As you will most likely know well by now, there is a lot to learn if you want to be good at Power BI. You need to learn skills across the 4 distinct areas as shown below. Ken, Miguel and I are really excited that we have released a new […]
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 […]
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 […]
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 […]
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 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 […]
The December 2020 version of Power BI desktop has just been released, and it is undoubtably the most important release since the first version way back in 2015. The super feature that has been released is an update to composite models using direct query of online datasets. The implications of […]
The Ghostbusters Ultimately Ignored this Advice. So Shall We. (Our daring joint podcast is now available here) Greetings, Excel-er-readers! Hi folks! Some of you may know me – I was the “OG” Power BI blogger starting back in 2010, and was the only game in town for years. Eventually though […]
I am sure you know, there are quite a few companies that provide online document storage for free, including Dropbox (which is my personal favourite) but also Google Drive and OneDrive Personal (Microsoft). This article today shows how you can load data from OneDrive Personal (stored in the cloud) directly […]