by Matt Allington | May 24, 2022 | Excelerator BI
I have many reasons for sharing content online. The main reasons are that I like sharing what I know, but also that I want to document how to complete a task for future reference. My article today ticks both of those boxes. How Many Employees by Period I’m calling...
by Matt Allington | May 18, 2022 | Excelerator BI
The May 2022 version of Power BI Desktop includes a very interesting and useful feature – Field Parameters. Today I will show you how to use this new feature illustrating with 3 (no, wait, 4) use cases – Chart Elements, Chart Axis, Table Contents and Permanent Ad hoc...
by Matt Allington | Apr 13, 2022 | Excelerator BI
What?! Exploding Measures I hear you say. Exploding, expanding, use which ever word you like; what I mean is when you want to remove any refence to a measure INSIDE another measure. Example Consider the 3 measures below. Total Sales = SUM(Sales[ExtendedAmount]) Total...
by Matt Allington | Apr 4, 2022 | Excelerator BI
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...
by Roland Szirmai | Mar 28, 2022 | Excelerator BI
Matt here. I want to do a brief introduction prior to handing over to Roland. I have known Roland for a couple of years now – he is a member of the Sydney Power BI User Group. What I didn’t know until very recently is that he has the same […]Read More » This...
by Matt Allington | Mar 2, 2022 | Excelerator BI
I always tell people in my training classes that the best way to become good at using Power BI is to get plenty of practice. Best case scenario, you would do something at work that will help you succeed in your job and hence you will get paid to learn. […]Read...