Excelerator BI can help you exploit your data using Power BI. Kick-Start Your Power Pivot Journey Get expert Power Pivot help so you can quickly turn any data into high value reporting assets. Power Pivot & Power BI Training and Coaching Not all Power Pivot training is made equal.
I recently attend 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! Anyway that got me thinking that it would be great to do something cool with Power BI […]
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, was that you needed to […]
I was explaining to one of my blog readers recently how to extract table size from Power BI Desktop using DAX Studio and thought it would be useful for others. I have covered the basics of DAX Studio in the past so I wont cover this detail again here. The latest version of DAX Studio can be […]
Level: Advanced The EARLIER() and EARLIEST() functions are 2 of the harder functions in DAX to get your head around. If you come from a programming background it will probably be easy for you. However as I have repeatedly stated on my blog, one of the many great things about Power BI is that it […]
Level: Intermediate I was helping someone on a forum recently and I thought the question and solution would make an interesting blog article. I have adapted the scenario to work with Adventure Works customer purchases, but this concept would work equally well across other entities, such as sales territories, calendar years etc. Problem Definition The […]
Level: Intermediate–Advanced I have covered the topic of Lineage in DAX a few times in the past (within other articles). Today I thought I would write a single post dedicated to lineage. As you may know, Power BI has a number of different operation modes, some of which do not require the data to be […]
Regular readers of my blog probably get sick of hearing me rave about the latest new thing in Power BI. This month there is an absolute cracker – Q&A in Power BI Desktop. In case you don’t know, Q&A is a natural language query tool that allows you to ask a question about your data […]
Level: Intermediate I have been aware of the TREATAS function for a very long time. I have tried to understand how it works a few times but could never really work it out. I think part of the problem is the function name TREATAS is not very descriptive. To contrast this point, the FILTER function […]
I’m really pleased and excited to introduce you to Daniil Maslyuk (Twitter: @DMaslyuk). I first met Daniil about a year ago (originally via email) as he was preparing to move to Australia. Daniil made the plunge shortly there after and migrated to Australia (from Russia) – he now works as a Power BI consultant for Agile BI here in […]
Where has Matt been? 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 a lot of training, finalising my new book Supercharge Power BI, and also taking a couple of weeks vacation. Side Story: Power […]
Read Full Article
Read for later
Articles marked as Favorite are saved for later viewing.
Scroll to Top
Separate tags by commas
To access this feature, please upgrade your account.