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

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

This week in our series about Microsoft Excel for Mac, we show you a handy feature that is only available in Excel if you’re using a Mac. There’s a great colour picker that lets you easily choose any color that you can see on your screen.

Welcome back to this week’s edition of the Power BI blog series. This week, we take a deeper look at the new Preview feature, visual calculations.

Welcome to our Power Query blog. Today, I look at using M code to provide an alternative solution to an issue that occurs when I load to a Table with no headers.

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

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new Preview feature in Power BI, visual calculations.

Welcome to our Power Query blog. Today, I refine the solution to an issue that occurs when I load to a Table with no headers.