Select Page

How Many Employees by Period

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...

Field Parameters in Power 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...

Exploding Measures using Tabular Editor 3

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...

Poor Man’s Paginated Reports in Power 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...

Dataflows 101

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...