On the final Friday of each month, we are going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you are playing for bragging rights only!

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at dynamic calendars that we can use for our analysis.

Welcome to our Power Query blog. This week I look at the importance of environment to Expression.Evaluate().

In our long-established Power Pivot Principles articles, we are starting a new series on the A to Z of Data Analysis eXpression (DAX) functions. This week it’s ACOS with no lettuce in sight…

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the ISNUMBER function.

Welcome back to our Charts and Dashboards blog series. This week, I look at another way to create a presentation of actual sales vs. target sales.

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at dynamic titles, and how to create titles with multiple linked values.

Welcome to our Power Query blog. This week, I look at the M function Expression.Constant().

In our long-established Power Pivot Principles articles, we are starting a new series on the A to Z of Data Analysis eXpression (DAX) functions. So how about take a brake and read about ABS…

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the ISNONTEXT function.