by Matt Allington | Apr 23, 2018 | Excelerator BI
I wrote a blog on this topic 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 I am going to write...
by Matt Allington | Apr 12, 2018 | Excelerator BI
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 I am talking...
by Matt Allington | Apr 3, 2018 | Excelerator BI
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...
by Matt Allington | Mar 12, 2018 | Excelerator BI
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...
by Matt Allington | Mar 5, 2018 | Excelerator BI
There are lots of different ways you can filter data 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...
by Matt Allington | Feb 26, 2018 | Excelerator BI
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. ...
