by Roland Szirmai | Jul 15, 2022 | Excelerator BI
Readers of my blog may have read this previous article from Roland where he covered an introduction to dataflows. In this new article, Roland is going to share some ideas about using the new field parameters. If you haven’t subscribed to Roland’s YouTube Channel yet,...
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...