Loading...

Follow Excelerator BI on Feedspot

Continue with Google
Continue with Facebook
Or

Valid


Excelerator BI by Matt Allington - 1w ago
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excelerator BI by Matt Allington - 2w ago
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excelerator BI by Matt Allington - 1M ago
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excelerator BI by Matt Allington - 1M ago
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excelerator BI by Matt Allington - 2M ago
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excelerator BI by Matt Allington - 2M ago
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 […]
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free year
Free Preview