Welcome to our Power Query blog. Today, I consider a challenge involving a choice of filters, and I begin by extracting and transforming the input data.

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

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

This week in our series about Microsoft Excel for Mac, we show how to create a forecast sheet, even though the ‘Forecast Sheet’ feature isn’t available on Mac.

This week, we revisit creating multiple ToolTips for one visual. Since the Power BI interface has been undergoing some transformations, we aim to provide a clear route to access this functionality.

Welcome to our Power Query blog. Today, I complete the challenge.

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

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

This week in our series about Microsoft Excel for Mac, we cover the security settings that are available to protect data from malicious actions i.e. cyber threats.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Custom Shape Map.