Level: Intermediate. I had a great question pass my way last week while I was at the Microsoft Business Application Summit. The problem presented by Matt (a different Matt, not me) was that he had around 200 measures already written, but wanted to be able to toggle the report pages […]
Microsoft has always been great at building and delivering world class robust commercial software, but it hasn’t always been great at listening to specific customer concerns about gaps in the software. All this has changed now, and Microsoft now has a clearly defined process to ask its customers what is […]
Level: Intermediate I do lots of live training, face to face and online, and I always encourage students to bring along any business problems they would like some help with. Last week I had a great problem that Debbie shared with me that I thought was worth creating this blog […]
Power BI gets a lot of love – and it deserves it. But under the hood you will probably know that there are 2 technologies that are the true work horses that prepare the data for use. Those 2 products are Power Query and Power Pivot. Power Query is the […]
Level: Intermediate I wrote an article earlier this year that showed how you can take a table of future growth rates (different growth rates each year) and then calculate the future value of an investment using DAX. I had a follow up question from Steve asking if it is possible […]
Last week, while I was taking a few days holiday from work, Avi Singh interviewed me via Skype and asked about my journey into Power BI. I have written about that over at PowerPivotPro.com originally here and then 3 years later here, but this is the first time I have […]
Level: Intermediate I got my haircut today (pretty spiffy one too, even if I do say so myself). While I was chatting I asked my hair dresser “on average, how often should I get my hair cut”? She told me (for men) around 4-6 weeks. Then I got thinking (as […]
I’m presenting again this year at SQL Saturday Melbourne (30th June 2018) and Sydney (7th July 2018). My topic this year will be “DAX as a Query Language“. What is SQL Saturday? SQL Saturday is an annual 1 day event that is held in many cities around the world. It is a day […]
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 […]
Level: Intermediate Last week I presented a webinar with Chuck Sterling (from Microsoft) on the topic of Time Intelligence. This was a YouTube broadcast event that anyone could join live, however it has also been recorded and can be watched at any time (see below). This article is a follow […]
Level: Intermediate. Sometimes, just when you think you are getting the hang of the DAX language, something happens that completely baffles you. Such events can cause you to doubt your own learning and progress. But let me assure you – this happens to EVERYONE at sometime or another. In this […]
Level: Advanced I was answering an interesting forum question last week, and as is often the case I thought it would make an interesting article to share with you all here. I have modified the scenario a bit for this article and have built out some test measures to help […]
I wrote a blog about Power Query calendar tables a few years ago over at PowerPivotPro.com. I have learnt a lot about Power Query since that time, plus Power Query has come along in leaps and bounds, and it now has a lot more capability than it had previously. Today […]
There are some things that are very easy to do in Excel that don’t seem to have an immediately obvious and simple solution in DAX. One such problem is when you want to apply compound growth on an investment. Let me make up an example so it is clear what […]
Ken Puls is coming again to Australia and once again he has generously offered to speak at the Sydney Power BI User Group. This time ‘round Ken will be talking on a broad topic around how Power BI and Excel are increasingly being enhanced to work together. Microsoft calls this […]
Today I want to issue a warning to anyone considering using Publish to Web to share corporate data internally within an organisation. Publish to Web is a standard feature on all Power BI accounts (free and Pro) – I first wrote about it two years ago here. This is a […]
There are lots of different ways that you use to do Text Filtering in Power BI including: Slicers (with various configurations) Cross filtering from any visual object The filters pane on the right hand side of your report Custom visuals designed specifically for filtering Most of these standard filters require […]
Power Query for Excel has developed at a striking pace over the last few years making it hard to keep up with the changes. Over several iterations, the Queries and Connections pane has been called various names, and the behaviour has changed a few times too. Depending on the version […]
I recently attended a school reunion (class of 1981 for what it’s worth – wow, I’m old!). We all had a great time catching up, looking at old photos, taking new photos etc – how things have changed! Anyways that got me thinking that it would be great to do […]
Changing Defaults In March 2017, the Power BI team delivered a new feature that allowed you to change the colour defaults in a Power BI report using a custom colour theme. I wrote a blog post over at PowerPivotPro.com at the time. The drawback of this feature, as it was back in March, […]
Excelerator BI | © 2023 | Sitemap