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 look at a new yet eerily familiar DAX function, NETWORKDAYS.

Welcome to our Power Query blog. This week, I look at how to access two Access databases.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at CONVERT.

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

Welcome back to our Charts and Dashboards blog series. This week, we’ll consider approaches we can take when we are missing data.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at recent improvement in the Power BI experience.

Welcome to our Power Query blog. This week, I complete the query to look for data in the current workbook.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at CONTAINSSTRINGEXACT.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the MODE function. The MODE function The mode is the value that appears most often in a set of data values....