Select Page

Calculating Business Hours Using DAX

I was helping a client this past week to calculate the total business hours between a start date/time and an end date/time, taking into account the working days, public holidays and non-working weekends, etc.  As is often the case, I thought it would be a great blog...

3 Great New Features in Power BI Desktop

Power BI is and incredible product, yet there are still niggling issues that can frustrate and annoy the best of us (me included).  Having said that, changes and improvements are happening all the time and it is easy for new features that address old issues to slip...

Small Multiples Using Zebra BI Custom Visuals

I see lots of chatter on Twitter and other media about the use of “small multiples” as a great way to communicate information across different subsets of data – yes Jeff Weir(d), that means you. I thought I would write a quick article about the concept to draw your...

Expression Based Formatting in DAX

There was a very subtle but important change made in the April 2020 release of Power BI Desktop that you may have missed. Take a look in the format pane on the right in the … Expression Based Formatting in DAX Read More This post first appeared...