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 […]
Paginated Reports have been available in Power BI since 2019. They serve an important purpose, but they are not easy for the average business user to learn, plus they require Power BI Premium to use. In my blog and video today, I will show you how you can use Excel […]
Ken Puls and I decided we would do a live stream chat to talk about a topic of interest to Power BI people. We put out a survey and 75% of the respondents wanted to hear about “when to use Power Query/M vs Data Modelling/DAX”. It’s a really interesting topic […]
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 […]
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 […]
This is a further (fourth) update/edit to this article Power BI Golden Dataset I first wrote in Apr-17. I then updated it again in Jan-18, Jun-18 and again now in May-20 (Jason did a full review this time around). When I update my articles, I change the original post with […]
It is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t realise this). One such example is shown below, where the data in the table on the left hand side needs to […]
I often get asked about how to create measure tables during my Power BI course classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes from. What is a Measure Table? A measure table is a dedicated table used […]
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 […]
I had a question from one of my online Power BI Training students just this week who was struggling to import data from a large *.xlsb Excel file. I suggested she save the file as an XLSX file and try again – and that worked a treat. But the question […]
One thing I did a long time ago was set up my own forum called PowerPivot Forum. This forum is open to anyone to join and to ask questions and/or help others. If I have any spare time (decreasingly so these days), I help people out on the forum too. It occurred […]
Matt Here: I first met Ivan via Twitter when he was living in Russia, and then in person when he moved to Australia to live in Sydney with his family. Ivan is a talented Power BI professional and I have learnt many things from him over the last few years. […]
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 […]
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 […]
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 […]
Where has Matt been? Before teaching you how to pass an Excel parameter to Power Query, I’ll have a few words. Regular readers of my blog may have noticed I have been missing in action over the last month. I have been super busy with the PUG World Tour, delivering […]
Level: Intermediate The variable feature in DAX has been around for more than a year and I have simply never got around to writing an article about it – I am changing that today. Let me start off with some version information and syntax and then I will show you are […]
Update 21 Feb 2018: There are 2 versions of this localhost workbook. One works with the downloadable version of Power BI Desktop and the other works with the Microsoft App Store version. There were some technical issues in late 2017, but as at Feb 2018 everything seems to be working […]
I have written articles before about how you can extract measures from a data model using DAX Studio and also using Power Pivot Utilities. These are both excellent tools in their own right and I encourage you to read up on those previous articles to learn more about these tools. […]
Level: Intermediate In this article I am going to write about the ALL() function, show how it works and explain a common use case. I will also cover the unexpected behaviour that occurs when using the ALL() function in Power BI Desktop – more on that later. For this article I […]
Excelerator BI | © 2023 | Sitemap